select data from three tables...

[gprasanth_kumar]

I have three tables Table_1 with a Primary Key(uid) and other tables Table_2(id) and Table_3(id) with foreign keys referencing Primary Key of table Table_1. Each one have 7-rows.

My problem is to retreive 1-st row from each table and display as a single row. I used select * from Table_1 t1,Table_2 t2, Table_3 t3 where t1.uid=t2.id and t1.uid=t3.id; but there are 49 rows being displayed in mysql...where as i would like to see the data in just 7rows...please help me....

Tanks in advance,
Prasanth Kumar G

[flann]

it sounds like you're doing a cartesian join. Could you post more info about the data.