Multi tables select query

SELECT  table1.field,  table2.field 

FROM  table1, table2 

WHERE table1.i1 = table2.i2;





SELECT summercamp.id   summid,

            <other fields from summercamp here>,

            table2.table2id,

            <other table 2 fields here>

FROM summercamp, table2

where summercamp.id = '.$idand table2.id = summercamp.id





SELECT mytbl.col1, m.col2 FROM mytbl, mytbl AS m WHERE mytbl.col1 



$sql = 'SELECT summercamp.id id, title, description, price 

tickets.id tkt_id, tkt_title, tkt_description, tkt_price 

FROM summercamp, tickets 

WHERE summercamp.id = '.$id' and tickets.id = '.$id;