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...
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"
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.