Hi,

I need to make a query against couple of tables:

tablemain: id, datamain

table1: id1, data1
table2: id2, data2
table3: id3, data3
table4: id4, data4
...................


id from tablemain is same as one (and only one) of the id's from table 1.....x

How i can make a query to grab data as: id, datamain, datax    where id = idx ?