Hi,
Because i don't like the mysql DELETE syntax, i prefer using this quick
method:
% create a new table = table1
CREATE TABLE Table3 (...)
% insert into table3 the records from table1 that aren't in table2
INSERT INTO Table3 (Table3.fields)
SELECT Table1.fields
FROM Table1 LEFT JOIN Table2
Hi , I would need help with the syntax for this:
I have Table1 and Table2. Table2 consists only of records that also exist in
Table1 (duplicates), and I wish to delete all the records in Table1 that are
matched in Table2, while keeping the rest of the records in Table1 intact.
Can anyone help?