Re: three table join - Mailing list pgsql-novice

From Vishal Kashyap @ [Sai Hertz And Control Systems]
Subject Re: three table join
Date
Msg-id 77b69d2104110208256a0aa573@mail.gmail.com
Whole thread Raw
In response to three table join  (Kumar S <ps_postgres@yahoo.com>)
Responses Re: three table join  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Dear Kumar


> I have two tables 1. Contacts and 2. Experiment.
> In this link table I have nothing but primary keys of
> experiment and contacts table.


Whats the relation between

Contacts and Experiment table.
If they relate to each other the link table can be filled (By filled I
understand insert)

But then if these both table are linked by some relation you wont
require to insert the data in the link table.
Just a join query would do that.

Does anyone has better idea then plz to enlighten us.


--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: three table join
Next
From: Sean Davis
Date:
Subject: Re: three table join