mysql table select php etc... (thanks).
Posted: Tue Apr 26, 2005 12:55 am
hey all. i have two tables that holds:
table1= A, B, C and a_id
table2= X, Y, Z and b_id
I want to select and align the record rows from table1 and table2 wherever a_id = b_id.
So i get to display:
A B C X Y Z wherever a_id in table1 is = b_id in table2
How do i write my SQL statement, and how do i retrieve the values!?! Thanks a mill guys (and girls).
table1= A, B, C and a_id
table2= X, Y, Z and b_id
I want to select and align the record rows from table1 and table2 wherever a_id = b_id.
So i get to display:
A B C X Y Z wherever a_id in table1 is = b_id in table2
How do i write my SQL statement, and how do i retrieve the values!?! Thanks a mill guys (and girls).