Greg Matthews wrote:
>clause) instead of EXISTS -- seems like a "tail wagging the dog" strategy.
>Isn't EXISTS a lot more efficient than an inner join?
Well, its more efficient if it exists, I guess ... but if it doesn't
exist on your platform (MySQL), then its pretty inefficient, really.
>We're going to offering the application on Oracle and so I wouldn't like to
>de-optimize the SQL just so it works on mysql 4.0 if 4.1 will be out within
>a few months.
If you're writing OO code, you might be able to easily flag your objects
as to whether to use one or the other query based on the underlying
database system (queried at run-time).
Michael T. Babcock
C.T.O., FibreSpeed Ltd.