Tom,
> This is absolutely NOT an error. iddomain in the subquery is a
> legitimate outer reference, if it's not otherwise known in the subquery.
> There is no clause in the SQL spec that says that outer references are
> invisible in any context ... even if it means you just deleted your
> whole table, which is what I think will happen here...
Yup, that's what happened.
Wasn't sure. We're OK then.
--
Josh Berkus
Aglio Database Solutions
San Francisco