NHier1992 NHier1992 - 1 year ago 70
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 Source

It means

Table1 t1 Left Join Table2 t2 on t1.Column1 = t2.Column2
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download