> Both the following query will throw same result (assuming empname aslo exist
> in Dept)
The issue is whether or not the referenced select column exists in the
sub-select table. If it does *not*, you get the behavior you've seen.
> Or Could u pls tell me exactly how the Optimizer transform the above
No offense, but could you stick to standard English spellings? I find
"online jargon" like "u pls" doesn't scan well and makes it more work for me
to read e-mails. Thanks!
Aglio Database Solutions
In response to
sfpug by date
|Next:||From: David Fetter||Date: 2003-12-16 22:51:50|
|Subject: Re: Bug or expected behaviour|
|Previous:||From: David Alban||Date: 2003-12-16 02:38:11|
|Subject: CORRECTION: No SIG-BEER-WEST event this month|