Jason, your severe lack of database programming experience is showing….
.
Where?!??!
The person who gets the reference above receives a bucket of pride.
Seriously, thanks to Cass I was reminded of the “IN” SQL operator. From the largest SQL Server book ever written:
Returns TRUE if the value to the left of the IN keyword matches any of the values in the list provided after the IN keyword. This is frequently used in subqueries.
Sure beats of the hell out of figuring out how to join the table back to itself.
Powered By Qumana
0 Responses to “Don't forget about the "IN" operator”