please help

I need to run a query to get all the items out of a table where they are not
in a different table... is this possible?
Thanks
GavinGav
SELECT * FROM TableA WHERE NOT EXISTS
(SELECT * FROM TableB WHERE TableA.col=TableB.col)
"Gav" <spam@.spam.com> wrote in message
news:#Rr6tAPDEHA.2564@.TK2MSFTNGP11.phx.gbl...
> I need to run a query to get all the items out of a table where they are
not
> in a different table... is this possible?
> Thanks
> Gavin
>|||perfect thanks for that
Regards
Gavin
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23Bn4AJPDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> Gav
> SELECT * FROM TableA WHERE NOT EXISTS
> (SELECT * FROM TableB WHERE TableA.col=TableB.col)
> "Gav" <spam@.spam.com> wrote in message
> news:#Rr6tAPDEHA.2564@.TK2MSFTNGP11.phx.gbl...
> not
>