> From: Phan, Robert [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 1:08 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Multiple select statements
> I *think* the problem lies in the fact that there are two select
> statements in the sql file. All the other ones that have multiple
> select statements suffer the same fate.
There's only one select statement. It happens to have a sub query though.
Though there doesn't seem to be any reason for the way its done (as a
virtual table rather than a regular join and filter).
Maybe it has something to do with optimizer rules in two different
environments, and not strictly because of DBI?
-Doug
