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
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
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 order