sql (where) 1

[pinstripe]

i have 3 tables (all 3 have identical fields but different data). in a form i have textbox in which i retrieve data from table 1 and a listbox - data from table 2 based on textbox.
then i am adding(copying) data from table 2 to table 3- but i get mixed data in listbox

now i would like to filter the listbox and view data which are not yet in the table 3

i have trouble geting the "where " right

 

[alvechurchdata]

You don't say what technology you're using but you need a sub-query:

[TT]SELECT * FROM thistable WHERE thistable.id NOT IN
(SELECT id FROM thattable)[/TT]

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[PHV]

Another way:
SELECT table2.* FROM table2 LEFT JOIN table3 ON table2.ID=table3.ID WHERE table3.ID Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pinstripe]

thx PHV
i've been doing this for hours ... trying evrything
possible... and i was so close
.... i am so happy
thx to you to "alvechurchdata