re: re: Delete from sub select

Kittiphum, Friday, December 06, 2002, 12:19:47 PM, you wrote: KW> REALFROM: Kittiphum Worachat <[EMAIL PROTECTED]> KW> On Wed, 4 Dec 2002 17:38:00 +0200, Victoria Reznichenko wrote: >>Kittiphum, >>Wednesday, December 04, 2002, 1:49:08 PM, you wrote: >> >>K> This query can find the record in Table

re: Delete from sub select

On Wed, 4 Dec 2002 17:38:00 +0200, Victoria Reznichenko wrote: >Kittiphum, >Wednesday, December 04, 2002, 1:49:08 PM, you wrote: > >K> This query can find the record in Table1 that not found in Table2 > >K> SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) >K> WHERE Table2.ID IS NULL > >K> an

re: Delete from sub select

Kittiphum, Wednesday, December 04, 2002, 1:49:08 PM, you wrote: K> This query can find the record in Table1 that not found in Table2 K> SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) K> WHERE Table2.ID IS NULL K> and what query that use to delete the record in Table1 that not found K>

Delete from sub select

Hi. This query can find the record in Table1 that not found in Table2 SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) WHERE Table2.ID IS NULL and what query that use to delete the record in Table1 that not found in Table2 such as Delete from Table1 where Table1.ID in SELECT Table1.I