From: | Bruce Young <hbrucey(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | displaying correct name |
Date: | 2003-03-14 03:11:28 |
Message-ID: | 20030314031128.15799.qmail@web10411.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi list!
I have two tables. One is contains User info, the other requesting info.
ownerid and buyerid are userid in the usertable.
Table "users"
Column | Type |
-----------+-----------------------------+
userid | integer | serial
username | character varying(25) |
password | character varying(32) |
Table "item"
Column | Type |
----------------+------------------------+
itemid | integer | serial
userid | integer |
title | character varying(100) |
Table "requests"
Column | Type |
------------+-----------------------------+
requestid | integer | serial
ownerid | integer |
buyerid | integer |
itemid | integer |
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
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2003-03-14 05:18:37 | Re: nearest match |
Previous Message | Stephan Szabo | 2003-03-14 01:55:01 | Re: date and plpgsql error |