Re: three table join

From: "Vishal Kashyap (at) [Sai Hertz And Control Systems]" <vishalonlist(at)gmail(dot)com>
To: Kumar S <ps_postgres(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: three table join
Date: 2004-11-02 16:25:28
Message-ID: 77b69d2104110208256a0aa573@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-11-02 16:39:08 Re: three table join
Previous Message Kumar S 2004-11-02 13:49:33 three table join