How to write this query! - Mailing list pgsql-sql

From Jo
Subject How to write this query!
Date
Msg-id 20030713163222.88233.qmail@web10305.mail.yahoo.com
Whole thread Raw
Responses Re: How to write this query!
List pgsql-sql
These are my PostgreSQL tables: 

pid | name 1  |  A 2  |  B 3  |  C 4  |  D 5  |  E 

tid | pid 1 | pid 2 | pid 3 
1   |  1    |  2    |  3 

Bascially, I would like to write a query to list only
the names which their "pid" match those pids in the
other table. If anyone knows, pls help!! 

Many Thanks!! 

Joe



________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/


pgsql-sql by date:

Previous
From: Scott Cain
Date:
Subject: Cannot insert dup id in pk
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with temporary table -- Urgent