Say you need to use this outer join in an information link (SQL Server): FROM TABLE1 T1 LEFT OUTER JOIN TABLE2 T2 ON (T1.COl1 = T2.COL1 AND T1.COl2 = T2.COL2) ...then the only options seem to be to either manually edit the SQL or to create a join using freehand syntax (example "C1*=C4 and C2*=C5 and C3*=C6" etc). Unfortunately this left join syntax has been depreciated in SQL Server 2008, why the only option is to manually edit SQL. Would like to be able to define outer joins with multiple join criteria.
