hello,

my problem is to delete some rows in a table by joining another table:

DELETE FROM
tableA
WHERE
tableA.rowA='1'
AND
tableB.rowB=tableA.rowA;

this produces errors:

SQL0206 "SCHEMA.TABLE.ROW" is not a valid in this context SQLSTATE 42703
Database is DB2 8.1.4 on NT

where is this error come from? i think its not possible to join another tables in a delete statement...is this right?

thank you!

poekel

Hi,

Try to write subselect, something like:

DELETE FROM
tableA
WHERE
rowA='1'
AND
rowA in (select rowB from tableB);

Hope this helps,
Grofaty

ok thanx, i try this...

poekel

yes it works!

thanx again...