TalkPHP - View Single Post

dschreck · 11-14-2007, 06:38 AM

just as a side note, not going to say ignorance is acceptable, but you'll rarely need to really consider which type of join you will need. Often enough, it is adequate enough to just simple come up with a query that resembles :

Code:

MySQL:

select 
    table1.* 
from 
   table1 
join 
   table2 
 on 
   (table1.specific_detail = table2.id)
where 
   table1.id = 5

and generally, this type of syntax will give you the results you desire.
But yes, learn the types of joins just in case things go.. askew.

11-14-2007, 06:38 AM	#5 (permalink)
dschreck The Contributor Join Date: Nov 2007 Location: California Posts: 82 Thanks: 0	just as a side note, not going to say ignorance is acceptable, but you'll rarely need to really consider which type of join you will need. Often enough, it is adequate enough to just simple come up with a query that resembles : Code: MySQL: select table1.* from table1 join table2 on (table1.specific_detail = table2.id) where table1.id = 5 and generally, this type of syntax will give you the results you desire. But yes, learn the types of joins just in case things go.. askew.