join on delete

[junebug]

now this sounds logical to me but please, shoot me down if its not. is it possible to do a join on a delete statement in mysql?

i have a table of numbers (invoices, po's) and a table of dates. if i want to delete values before a certain date, i want to join the tables and delete all values from both tables. is that possible?

thanks in advance for the help.

[toma42]

it's not possible in any dbms. Read sql manuals for more details.

[Anon]

Hi,

In a simple word..NO.

Cheers

Clive

[arcelio1023]

In transact sql you can use the following:

delete from pubs..auth1 where not exists
(select distinct au_lname from Northwind..auth2 as x
where auth1.au_lname = x.au_lname)

For this example I created 2 tables identical to the SQL Server pubs author table and copied one into Northwind (auth2)and one into pubs (auth1).

Then delete some records from Northwind..auth2. Your identical tables are now out of synch. Run the query above from pubs database and your tables will synch back up based off of the Northwind auth2 table. Depends which table you want to synch up with.
This process is called synching of tables.