left join with more tables

[Tal]

hello

i have 4 tables and i need to join them. The 1st table has about 1M records and the other 3 about 20M each but i only need all the records from the 1st with all the coresponding ones  from the  other 3 tables which means left  join on the 1st table would do the job,right?

But how do i do left join with more then   2  tables?

[morgalr]

Here is a link to the question asked for MySQL http://stackoverflow.com/questions/7980052/how-to-do-left-join-with-more-than-2-tables

the proc sql syntax should be very similar.

[PGStats · Accepted solution]

The basic structure is like this:

select a.*, b.x, c.y, d.z

from a left join

  b on a.id=b.id left join

  c on a.id=c.id left join

  d on a.id=d.id

Keep referring to the first table for the joins.

PG

[Tal]

thanks. This is really siimple