Delete with join in mysql 4.0.2

I have just upgraded to mysql 4 to be able to perform delete queries with join statement. I have a simple query where I would like to delete a number of rows in tabel t1 depending on id's found in table t2. This doesn't seem to work and I just don't understand why!? mysql delete icl from

Re: Delete with join in mysql 4.0.2

Christian, Saturday, August 31, 2002, 11:09:47 AM, you wrote: CL I have just upgraded to mysql 4 to be able to perform delete queries CL with join statement. I have a simple query where I would like to delete CL a number of rows in tabel t1 depending on id's found in table t2. This CL doesn't

Re: Delete with join in mysql 4.0.2

Christian Longberg wrote: I have just upgraded to mysql 4 to be able to perform delete queries with join statement. I have a simple query where I would like to delete a number of rows in tabel t1 depending on id's found in table t2. This doesn't seem to work and I just don't understand why!?