re: re: Delete from sub select

2002-12-06 Thread Victoria Reznichenko
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

2002-12-05 Thread Kittiphum Worachat
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

2002-12-04 Thread Victoria Reznichenko
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>