Is it possible to create sub select statements in a view?
I'm being asked to do something like this...
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