emp_table(
Cdacno varchar (7) (primary key),
Personal_No varchar (10)(foreign key),
Name varchar (40));
personal_table (
Personal_No varchar (10) (primary key),
Cdacno varchar (7),
Date_Of_Birth date);
unit_master (
Unit id varchar (10) (primary key),
Unit_Name varchar(25),
Unit_Location varchar(25));
Unit_Details_table (
Unit_id varchar (foreign key)
CDA_No varchar(7) foreign key);
rank_table(
Rank_ID numeric(2)(primary key),
Rank_Code numeric(2),
Rank_Name varchar (25));
Rank_Date_table (
Rank_Date__ID numeric NOT NULL,
CDA_No varchar(7) (foreign key),
Rank_ID numeric(2));
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..
Like that if I give per_no I have to get cdacno from emp_table.. .. With this I have to display rank_name from rank_table ,name from emp_table, unit_name from unit_master..
And here unit_name is depends on unit_details_table ..and rank_name is depends on rank_date_table..
Doing these things first it has to check when we r giving cdacno.. whether per_no is null or not.. like this if I give per_no it has to check cdacno is null or not.
Let me know the solution..
But I written one function to this to get per_no if I give cdacno………………….
