Postgres Pro
Downloads
Home   >   mailing lists

three table join - Mailing list pgsql-novice

From Kumar S
Subject three table join
Date
Msg-id 20041102134933.60092.qmail@web51408.mail.yahoo.com
Whole thread Raw
Responses Re: three table join  ("Vishal Kashyap @ [Sai Hertz And Control Systems]" <vishalonlist@gmail.com>)
Re: three table join  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question regarding string returned from PQgetvalue
Next
From: "Vishal Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: three table join