RE: How to write delete query??

to be happy. -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 6:35 AM To: [EMAIL PROTECTED] Subject: How to write delete query?? SQL SQL hi all, i have a query that works just fine on Dbase, but just crashes on mysql. How can i write

RE: How to write delete query??

thanx joe, i checked. I just thought that there could be a way around this problem! From: Joe Stump [EMAIL PROTECTED] To: Inandjo Taurel [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: How to write delete query?? Date: Mon, 17 Feb 2003 09:46:53 -0800 MIME-Version: 1.0 Received: from

Re: How to write delete query??

Inandjo, - delete from table1 where table1.field1 in (select distinct field2 from table2). Subselects (or nested queries) like that are supported as of MySQL 4.1. At this moment, you will have to compile 4.1 yourself; it's expected to be out as a binary version in the next couple of weeks. The

RE: How to write delete query??

17, 2003 8:35 AM To: [EMAIL PROTECTED] Subject: How to write delete query?? SQL SQL hi all, i have a query that works just fine on Dbase, but just crashes on mysql. How can i write it in one statement for it to work both on Dbase and mysql? the query: - delete from table1 where table1.field1