multiple table query

[turnknuckle]

Greetings

How do i go about querying multiple tables in an access db ie i need to check if a value is present in any of the tables in the database, is there a way to do it with 1 SQL query?

Thanks

[BigDaddy]

You need to join them. It's not hard to do, just read up on it at this link.

http://www.w3schools.com/sql/sql_join.asp

[whammy]

Good link. :)

[turnknuckle]

nice one - thanks alot :thumbsup: