Norris,
Saturday, October 12, 2002, 2:11:36 AM, you wrote:
NJ> I have the following query:
NJ> select phones.*, ops.plid, ops.box, ops.mac
NJ> from phones, ops where
NJ> (ops.box = 'Mcds') or (ops.box = 'Mn3300') and
NJ> (phones.suffix1 = ops.phone) order by ops.mac
NJ> When I change the or
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
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