From: Ragnar <gnari@hive.is>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: i need solution to this problem
Date: Wed, 28 Jun 2006 07:34:09 +0000
Message-ID: <1151480049.28621.29.camel@localhost.localdomain> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C9068C7BA6@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C9068C7BA6@venus.infics.com>
On mið, 2006-06-28 at 11:15 +0530, Penchalaiah P. wrote:
> I have tables like 1) emp_table (personal_no integer (foreign key),
> cdacno varchar (primary key),name varchar);
> 2) Rank_table (rank_id varchar (primary key), rank_name varchar);
> 3) Rank_date_table (rank_id (foreign key), rank_date date);
> 4) Unit_table (unit_id varchar (primarykey), unit_name varchar);
> 5) Personal_table (per_no varchar (primary key), pername varchar);
> My query is ….if I give cdacno I have to get per_no from
> personal_table.. With this I have to display rank_name from
> rank_table ,name from emp_table, unit_name from unit_master..
it is not clear what the relationships are between the tables. for
example what is the foreign key to unit_table?
how does the rank connect to emp_table or personal_table?
gnari
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gnari@hive.is, penchalaiahp@infics.com
Subject: Re: i need solution to this problem
In-Reply-To: <1151480049.28621.29.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox