hi
I want to fetch data from four tables using a single query.please tell me how to do that.
thanks in advance
lydia21
9
Junior Poster
Recommended Answers
Jump to Posthi
I want to fetch data from four tables using a single query.please tell me how to do that.
thanks in advancetry select * from a, b, c, d
then sort out at your leisure :D
Jump to Postselect table1.*,table2.*,table3.*,table4.* from table1 inner join table2 on table1.column1=table2.column1 inner join table3 on table1.column1=table3.column1 inner join table4 on table1.column1=table.column1
change table names and column names accordingly
All 7 Replies
tesuji
135
Master Poster
varmadba
12
Junior Poster in Training
varmadba
12
Junior Poster in Training
tesuji
135
Master Poster
varmadba
12
Junior Poster in Training
tesuji
135
Master Poster
varmadba
12
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.