joins

[glenelkins]

Hi

 

Im having a little trouble grasping joins.

 

I can do the basic joins such as:

 

SELECT t1.`field`, t2.`field` FROM `table1` t1, `table2` t2 WHERE t1.`id` = t2.`id`

 

But what i need to do is the following:

 

select 3 items from table 1 and 3 fields from table 2 and 1 field from table 1. They need to be selected by matchin an id from table 1 and 2, and a field from table 2 with table 1

 

does this make sense?

[revraz]

Provide your table structures for all 3.