Re: [SQL] i need solution to this problem

> > 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 (

Re: [SQL] 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

[SQL] i need solution to this problem

Hi good morning to all……..   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_dat