Left Outer Join with only 1 result
Posted on 2013-01-18
I want to run a sql query using a left outer join, but I only want to return the first result, not all.
So when the rows are joined we have:
ParentID 2& Id1 only, not ID2 and ID3.
How do I do that?
I want to check the null value of the Id1 column to see if there is a record in that table, but I definitely don't want my parent row to show up 3 times, just the once.