Is it possible to create sub select statements in a view?
I'm being asked to do something like this...
dbo.Table6 ON dbo.Table2.Col7 = dbo.Table7.Col5 LEFT OUTER JOIN ... etc
you can either move that WHERE snippet to the end of the query as a regular where clause, which makes sense with the left table of a LEFT OUTER JOIN...
or you can do it inline like you have it with an and
though I do have to wonder why you would LEFT OUTER JOIN Table3 with a test for equality between columns Table4 and Table5 (maybe Table5.Col1 is Table1.Col5?)
answered Jun 17 '11 at 03:32 PM