UUUUPPPS!!!!!
Arme esta consulta pero no me respeta lo que hay en la clausula where:
Código SQL
[-]
SELECT a.logdate, a.logtime, a.node, a.channel, a.phone, a.lengthcall, a.calltype, a.campaign, a.taxid,
b.posnumber, b.agentid, b.skill
FROM LOGCALL a LEFT OUTER JOIN logpos b on (a.callrefid = b.callrefid)
where a.logdate = '20120702'
and (a.CALLTYPE = 'I')
OR ((a.CALLTYPE = 'O') AND (a.RESULT IN ('10','18','1004'))
AND (a.PHONE <> ''))