NHier1992 NHier1992 - 10 days ago 6
SQL Question

Is this an inner join in the on clause?

Morning Folks,

This is my first encounter with joins being included in the WHERE clause and I'm probably going to ask a pretty basic question but is the following code snippet the equivalent to an INNER JOIN;

AND (Table1.Column1 = Table2.Column2(+))


I've been given a query taken from a business objects report and I'm trying to reproduce it in management studio with TSQL.

Answer

It means

Table1 t1 Left Join Table2 t2 on t1.Column1 = t2.Column2