[thelist] Joins in Mysql
Adrian Fischer
adrian at logo-logic.com
Wed Dec 26 00:02:34 CST 2001
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
More information about the thelist
mailing list