LEft joining same tables multiple times

[bhca60]

Thank you!!!

[PaigeMiller]

But we still don't know what output you want. You haven't told us. Someone made a guess and said this will "get you closer".

[AhmedAl_Attar]

Hi @bhca60 

Have a look at the attached pdf file, it has some visual illustrations of various SQL Operations and Statements.

Note: Some of the contents may not be supported by SAS's Proc SQL (Window Functions), but for the most part, it should provide you with good overview of how SQL works.  

Hope this helps,

Ahmed