var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: delete statement over 2 tables
my problem is to delete some rows in a table by joining another table:
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?
Try to write subselect, something like:
rowA in (select rowB from tableB);
Hope this helps,
Last edited by grofaty; 12-01-03 at 07:42.
ok thanx, i try this...
yes it works!