problem joining multiple tables

[buzztrex]

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;

 

[rcurva]

Any errors generated?
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[buzztrex]

i am running this query thru perl.
so when i terminated the perlscript, it exits saying "there was no statement executing, perhaps you should call execute earlier"

 

[sghosh83]

Could you please provide the table description

Soumen

 

[buzztrex]

i should have done that before, here goes:
another clarification, the query doesn't work not for anything besides items.id.

HARSHNESSDATA
(
ItemID ,
userID ,
negR ,
neutR ,
posR ,
noneR ,
negG ,
neutG ,
posG ,
noneG ,
Partnercount
);

key is : itemid+userid

items:
(
id,
title,
description,
seller,
high_bidder,
sale_price
)

key: itemid

tempids:
(id,seller,high_bidder)