Re: SQL question; Please Help!

Thanks for replying

however that is the improper use of the IN keyword. In selects records that exists in the list of values in the following parentheses, in your example provided by the subquery,

ie. Select * from tablex where b_day in (1970,1971,1972)

Your example would work if you concantenated the values assuming they are not numbers,

ie Delete from t1 where a||b in (select a||b from t2);

however this works only on char fields

Gerard H. Pille wrote in message <01bcde42$34e59440$e81beec3_at_pcghp>...
>delete from t1 where (a,b) in (select a,b from t2);
>--
>Kind reGards,
>
>Gerard
>(ghp_at_santens.be; ghp_at_skynet.be)
>
>Ivan Tung <ivant_at_direct.ca> schreef in artikel
><62hjf0$49l$1_at_brie.direct.ca>...
>> I have 2 identical tables structures t1, t2.
>> I essentially want to do an insert and update on t1 from t2.
>> I plan to delete all rows in t1 that exists in t2 then insert all the
 rows
>> in t2 into t1.
>> The deleting is where I am having trouble.
>
Received on Tue Oct 21 1997 - 00:00:00 CDT