i am able to run the following query:
select items.id,
b.userid,b.negg,b.neutg,b.posg,b.noneg,b.negr,b.neutr,b.posr,b.noner,
s.userid,s.negg,s.neutg,s.posg,s.noneg,s.negr,s.neutr,s.posr,s.noner
from items,endharshness b,endharshness s,tempids
where items.id=tempids.id and
b.itemid=tempids.id and
b.userid=tempids.high_bidder and
s.itemid=tempids.id and
s.userid=tempids.seller;
(id is the key on the items table)
but when i try to retrieve any column besides id, like
in the following query, oracle just hangs.
i am truly baffled, can anyone help ?
select items.*,
b.userid,b.negg,b.neutg,b.posg,b.noneg,b.negr,b.neutr,b.posr,b.noner,
s.userid,s.negg,s.neutg,s.posg,s.noneg,s.negr,s.neutr,s.posr,s.noner
from items,endharshness b,endharshness s,tempids
where items.id=tempids.id and
b.itemid=tempids.id and
b.userid=tempids.high_bidder and
s.itemid=tempids.id and
s.userid=tempids.seller;
select items.id,
b.userid,b.negg,b.neutg,b.posg,b.noneg,b.negr,b.neutr,b.posr,b.noner,
s.userid,s.negg,s.neutg,s.posg,s.noneg,s.negr,s.neutr,s.posr,s.noner
from items,endharshness b,endharshness s,tempids
where items.id=tempids.id and
b.itemid=tempids.id and
b.userid=tempids.high_bidder and
s.itemid=tempids.id and
s.userid=tempids.seller;
(id is the key on the items table)
but when i try to retrieve any column besides id, like
in the following query, oracle just hangs.
i am truly baffled, can anyone help ?
select items.*,
b.userid,b.negg,b.neutg,b.posg,b.noneg,b.negr,b.neutr,b.posr,b.noner,
s.userid,s.negg,s.neutg,s.posg,s.noneg,s.negr,s.neutr,s.posr,s.noner
from items,endharshness b,endharshness s,tempids
where items.id=tempids.id and
b.itemid=tempids.id and
b.userid=tempids.high_bidder and
s.itemid=tempids.id and
s.userid=tempids.seller;