three table join

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: three table join
Date: 2004-11-02 13:49:33
Message-ID: 20041102134933.60092.qmail@web51408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Group,
I have two tables 1. Contacts and 2. Experiment.

I have another link table con_exp_link table.

Contacts
Con_id
con_fname
con_lname
con_address

Experiment
exp_id
exp_name
exp_scientist
exp_publication.

con_exp_link
con_exp_id
con_id
exp_id

In this link table I have nothing but primary keys of
experiment and contacts table.

Now my question:

How can I fill the link table. I am highly confused.

Can any one help me please.

thanks

kumar.


__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vishal Kashyap @ [Sai Hertz And Control Systems] 2004-11-02 16:25:28 Re: three table join
Previous Message Tom Lane 2004-11-01 15:38:49 Re: Question regarding string returned from PQgetvalue