Finding a variety of unique items in one single search

[Pelle]

If I'm in the table "tblSerialnumber" in the field "fldSerialnumber" has 2000 entries with unique serial numbers and want to search in one single query for all the following unique serial numbers (which I eg copy from a text file) without having to create a new query for any unique value, how do you do this?


Serial Numbers searching for:
BCB4482485
BCB0557310
BCB7902211
BCB8060948
BCB1211498
BCB8305776
BCB2892737
BCB1073679
BCB2491353
BCB5670921
BCB8184432
BCB6502056
BCB7619120
BCB1694482
BCB0781208


BCB2005955
BCB3529747
BCB8644912
BCB7588380
BCB5141701


Thanks in advance for your help on the subject!


Best regard, s

Pelle

[CJ_London]

something like

SELECT Snum
FROM myTable
GROUP BY Snum
HAVING Count(Snum)=1

edit

misunderstood question

try copy your list into a temporary table

then your query would be

SELECT U.*
FROM myTable U INNER JOIN tmpTable T ON U.Snum=T.Snum

[Pelle]

try copy your list into a temporary table

then your query would be

SELECT U.*
FROM myTable U INNER JOIN tmpTable T ON U.Snum=T.Snum

[/QUOTE]

Hi Ajax.

Thank you very much for all your help.

It works great after I had changed it little in your SQL-Query as:

SELECT myTable.U FROM myTable
INNER JOIN tmpTable ON myTable.U = tmpTable.T;

Best regard, s

Pelle

[CJ_London]

think you have misunderstood how aliases work, but if you have it working, that is the main thing