Querying from 2 Tables!!! 1

[pete321]

i'm pretty knew at MySQL. i'm using PHP to access the database.

Here's my problem!:

i have two databases...let's call them DB and REG).
- DB contains ALL my records with a unique ID.
- REG contains ONLY the records who have Registered and can be linked to DB with the ID key.

i want to write the following query:
*** Select ALL records from DB that are NOT in REG. ***

i can do it by querying each ID from DB and searching for it on REG, but i was wondering if there's a one shot statement?!

Thanx!!!

 

[sleipnir214]

Are these two databases or two tables or two tables in different databases?


But it can be done. Use a LEFT JOIN.

Something like:

SELECT
*
from
<REG_tablename>
LEFT JOIN
<DB_tablename>
on
<REG_column_matching_DB_column> = <DB_column_matching_REG_column>
WHERE
<DB_column_matching_REG_column> is null


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!