SELECT csaldos.empcode, cmaprpro.caupro
FROM csaldos
INNER JOIN cmaprpro ON csaldos.proyec LIKE cmaprpro.proyec

132 DB2 SQL error: SQLCODE: -132, SQLSTATE: 42824, SQLERRMC:
727 DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-132;42824;

Obiously, this is an illegal use of operator LIKE but, anyone could write to me an alternative way of get the same?

Hi,

LIKE can only be used in where cause.
Write something like:

SELECT csaldos.empcode, cmaprpro.caupro
FROM csaldos
INNER JOIN cmaprpro ON (csaldos.proyec = condition) WHERE cmaprpro.proyec LIKE condition.

Hope this helps,
Grofaty

What would you like to do? LIKE or JOin?

If join:
SELECT csaldos.empcode, cmaprpro.caupro
FROM csaldos
INNER JOIN cmaprpro ON (csaldos.proyec = cmaprpro.proyec)

or

SELECT csaldos.empcode, cmaprpro.caupro
FROM csaldos, cmaprpro
WHERE csaldos.proyec = cmaprpro.proyec