[thelist] Joins in Mysql

[Adrian Fischer]

Hi Gang,

I hope someone out there isn't celebrating Christmas so much that they cant
answer my question (a bit sad really, isn't it)

I have 2 separate tables.
One table (table_1) has "ID" and "Password" (plus other columns)
The other table has(table_2) "ID" (plus other columns)
The "ID"  are identical in both tables
 I need to be able to confirm that "ID" exists in table_2 and that the
password given is correct in table_1

Something like:
SELECT ID,Password from table_2.table_1 where ID=$form{id'}

can you tell I know very little about joins??

Can any body help?

Regards

Adrian Fischer