Not Exists?

[Shawn12]

I know in Oracle SQL you can do NOT EXISTS..like this in the WHERE clause..

AND NOT EXISTS
(SELECT 'x'
FROM AX
WHERE AX.EMPLOYEE_ID = D.AGENTLOGIN
AND D.TIMESTAMP BETWEEN AEX.BLAH AND AEX.BLAH1
AND AEX.ROLL_ID = O.ROLL_ID)


Is there an equivalent in JET SQL?

 

[PHV]

Yes, same syntax.

 

[HarleyQuinn]

You can join to that query (or table etc) and check where the joined value IS NULL.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Shawn12]

Thx much.