From: | Colin Dick <cdick(at)mail(dot)ocis(dot)net> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Multiple table selection. |
Date: | 1998-08-05 15:37:00 |
Message-ID: | Pine.LNX.3.96.980805082711.17202B-100000@ocis.ocis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I am new to the more complex SQL statements and I am having
trouble creating the statement I need.
I have two tables:
table a table b
------- -------
idnum (unique) idnum (unique)
firstname phone
lastname fax
I want to be able to search the table for any value (sometimes multiple
values) and bring back all the information for all tables with the same
idnum. Would a query similar to the following do it.
select a.idnum, a.firstname, a.lastname, b.phone from a, b where
a.firstname='bob' and b.fax='123-4567' and (a.idnum=b.idnum);
Does that statement make sense? Or can someone make a suggestion to help
me acclomplish the task. Thadvanceanks...
--
Colin Dick
On Call Internet Services
cdick(at)mail(dot)ocis(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | James Olin Oden | 1998-08-05 15:49:00 | Re: [SQL] How do I get the list of table names in db |
Previous Message | Sergei Barbarash | 1998-08-05 13:35:59 | cursor results count |