if exists query in ms access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

devalbhavsar@gmail.com - 24 Nov 2005 09:25 GMT

I want to check weather records avail in some table on some conditions
, right now i have to use the select count(*) in ms access,

performance point of view i can use if exists in ms sql, is there any
way we can do it in ms access also.

with regards
deval bhavsar

Reply to this Message

Allen Browne - 24 Nov 2005 09:59 GMT

You can use a subquery in the WHERE clause to see if any match exists in
another table.

Example:
SELECT Table1.* FROM Table1
WHERE EXISTS (SELECT ID FROM Table2
WHERE Table2.ID = Table1.ID);

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I want to check weather records avail in some table on some conditions
> , right now i have to use the select count(*) in ms access,
>
> performance point of view i can use if exists in ms sql, is there any
> way we can do it in ms access also.

Reply to this Message