ss1289
01-23-2008, 08:01 PM
I want to join all the info in two tables to use for comparing. In each table there is a row that has an id of the rows that I want to pull from the database. These id's are the same in both tables.
So basically is there a way to pull all the info from both tables using the * that have the same id's?
Something like:
SELECT * FROM table a, table b WHERE a.id = 'id' AND b.id = 'id'
I know this doesn't work, but what way would work?
So basically is there a way to pull all the info from both tables using the * that have the same id's?
Something like:
SELECT * FROM table a, table b WHERE a.id = 'id' AND b.id = 'id'
I know this doesn't work, but what way would work?