Lamentablemente no me esta funcionando.
Aclaro que
LOGPOS no tiene un campo
CALLREFID1 solo
CALLREFID
Lo puse asi, no se si esta correcto:
Código SQL
[-]
SELECT A.CALLREFID, A.CALLREFID1, A.LOGDATE, A.LOGTIME, A.PHONE, A.LENGTHCALL,
B.POSNUMBER, B.AGENTID, B.SKILL
FROM LOGCALL A
LEFT OUTER JOIN LOGPOS B ON (A.CALLREFID = B.CALLREFID)
LEFT JOIN LOGPOS C ON (A.CALLREFID1 = C.CALLREFID)
WHERE A.LOGDATE BETWEEN '20120701' AND '20120707'
AND ((A.CALLTYPE = 'I') OR ((A.CALLTYPE = 'O')
AND (A.RESULT IN ('10','18','1004')) AND (A.PHONE <> '')))
No me da error pero me trae montones de registros repetidos.