Re: Combinatorial problem - Mailing list pgsql-novice

On Tue, Nov 29, 2005 at 03:44:10PM -0800, Srinivas Iyyer wrote:
> Now my question is how can I ask SQL the question:
>
> For T3 what are the Drugs ?
> For T4 what are the drugs?
>
> For a group of drugs m1,m3,m5 what are the targets?

I think you're looking for a join.  These parts of the PostgreSQL
documentation should help:

http://www.postgresql.org/docs/8.1/interactive/tutorial-join.html
http://www.postgresql.org/docs/8.1/interactive/queries-table-expressions.html

You could also google for words like "sql tutorial join".

--
Michael Fuhr