fi-claudemir writes:
> I 'm trying to use a sub-select to delete the lines that are in the
> table2 but are not in the table1
> but I didn't get it.
If you had bothered to read the manual you would've known
that subselects aren't implemented yet, and there's no way
to specify more than one tab
Hi
I'working with two tables (table1 and table2).
I 'm trying to use a sub-select to delete the lines that are in the
table2 but are not in the table1
but I didn't get it.
Below the way I've tried:
DELETE FROM Table1 SELECT Table1.* FROM Table1 LEFT JOIN Table2 ON
Table1.ID=Table2.ID WHERE T
