Bruce Young wrote: <cut>
what i want to do is select from "requests" where ownerid=<integer>. the result should contain the users.username of requests.buyerid and the item.title of requests.itemid. my problem is... i am getting the username of requests.ownerid instead from my query. here is my query:
select u.username, i.title from test.requests r, test.users u, test.items i
where r.ownerid=u.userid and r.itemid=i.itemid
and r.ownerid = (select userid from test.users where userid=1);
thanks.
any help appreciated.
- bruce
??? As you answered yourself in description above, change r.ownerid=u.userid into r.buyerid=u.userid
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
