Posted by Diogenes on 10/11/06 15:48

KrunoG wrote:

> Here's the 2nd option (for Oracle)
> select o.*
>
> from offer o, norm n
>
> where n.TF=o.PHONE
>
> and not exists (select 1 from norm n where n.TF=o.PHONE)
>
> --Put indexes on joined vars
>

I did try something similar to that. It becomes a
correlated SELECT statement yielding a cartesian product
which then needs a DISTINCT clause to get what I wanted.

I can't remember if I tried this with PHP. It did work from
the MySQL command line; but then so did my original query.

Do you think it might be a bug in PHP?

Cheers
Jim

[Back to original message]