Just try it, Ivan.
--
------------
Kind reGards
\ / |
X |
/ \ x
Gerard
Ivan Tung <ivant_at_direct.ca> schreef in artikel
<62jt5m$g3m$1_at_brie.direct.ca>...
> 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 Wed Oct 22 1997 - 00:00:00 CDT
