[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