Since it can't use an index, and has to sort the output, what
exactly is unexpected?
Norris, Joseph wrote:
>Group,
>
>I have the following query:
>
>select phones.*, ops.plid, ops.box, ops.mac
>from phones, ops where
>(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
>(phones.suffix1 = ops.phone
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces results
