Re: i need solution to this problem

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

>