How to build multiple left joins in Report Studio?

[elee123]

Hello Everyone,

I've got an example below that involves 3 to 4 left joins to the same table, but the Join in Report Studio's Toolbox only allows me to join 2 tables together . So how can I achieve this in Report Studio?

Select field1, field2 From Table1
LEFT JOIN Table2
ON Table1.field2 = Table2.field2;
LEFT JOIN Table3
ON Table1.field2 = Table3.field2;
LEFT JOIN Table4
ON table1.field2 = table4.field2;