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