Can someone show me an example of using two joins in ONE sql statement.

I need to join the first two tables based on a primary key, and the third table will b joined to the second based on a different primary key....

Can someone give me a simple/quick example of how this could be done.
The first and second should be a LEFT JOIN because a record that is in the first table may or may not be in the second.

Thanks in advance

I'm gonna download the internet if its the last thing I do....
Until the algorithm is finished u must prepared to bow down and worship me (or my grave).... i figured i'll b finished b4 the latter!

__________________
I\'m gonna download the internet if its the last thing I do....
Until the algorithm is finished u must prepared to bow down and worship me (or my grave).... i figured i\'ll b finished b4 the latter!

SELECT <fields> FROM <TABLE1>
LEFT JOIN <TABLE2> ON TABLE1.PK1=TABLE2.PK2
LEFT JOIN <TABLE3> ON TABLE2.FK2=TABLE3.PK3 -- just keep adding lines like this for more tables

Can two joins be made on a pk in say table one. can i do like a double inner join so that table 2 and table 3 both do a left join on table 1?

I'm gonna download the internet if its the last thing I do....
Until the algorithm is finished u must prepared to bow down and worship me (or my grave).... i figured i'll b finished b4 the latter!