Page 1 of 1
Grabbing data from two tables
Posted: Sat Aug 30, 2003 8:00 pm
by tsm4781
If I want to grab data from two tables is it...
SELECT * FROM table1, table 2 WHERE id = $id ??
Posted: Sat Aug 30, 2003 8:24 pm
by McGruff
Do you mean get rows in each table with the same id value?
A JOIN query such as:
"SELECT t1.col1, t1.col2, t1.col3, .. etc .. , t2.col1, t2.col2 .. etc .. FROM table1 AS t1, table2 AS t2 WHERE t1.id = t2.id";
Posted: Sun Aug 31, 2003 1:28 am
by JAM
Or similiar to McGruff's example:
Code: Select all
select
tablea.*, tableb.*
from
tablea
inner join tableb on tablea.id = tableb.id
where
tablea.id = '$id'
Posted: Mon Sep 01, 2003 12:35 am
by mcp
How would this work for grabbing all information when there is a 1:n relationship between the data?
The case I am thinking about is where there is an item table and a user table. Each item can have multiple users associated with it. The item table references the user table by ids. The user table has things like first name, last name, email, etc.
How do I grab all user's user data that is associated with a particular item?
I can do the join (like described earlier in this thread) to get one, but not all users...
Thanks!
mcp
Posted: Mon Sep 01, 2003 5:34 am
by JAM