Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem joining multiple tables
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...- buzztrex
- Post #5
- Forum: Oracle: All versions
-
problem joining multiple tables
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"- buzztrex
- Post #3
- Forum: Oracle: All versions
-
problem joining multiple tables
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...- buzztrex
- Thread
- Replies: 4
- Forum: Oracle: All versions
