[thelist] an elegant correlated sub-query that doesn't want to

r937 rudy at r937.com
Tue Apr 14 21:23:37 CDT 2009


sadly, the elegant subquery has a couple warts    ;o)

this part requires further explanation --

     WHERE o.OptionID IN (i.OptionID)

the only time i've seen people do this, it is because the column value 
inside the IN list is actually a comma-delimited string of id numbers

is this the case here?

or is i.OptionID actually just a single number?


rudy
http://simply-sql.com/






More information about the thelist mailing list