faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

12 of 36 people (33%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

how do i join 3 tables where one of them a map table the other 2 contain actoual data?

Feb 24th, 2008 00:21
dman, Euan MacInnes, Arman Galstyan, http://www.ttnr.org


If you want to do a straight join, then do it like so:
select * from
actual1,map,actual2
where actual1.id=map.actual1_id
and actual2.id=map.actual2_id
Assuming this is what you were asking