|
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
Navigation:
[Reply to this message]
|