Re: can any one solve this problem

["Aaron Bono" <postgresql(at)aranya(dot)com>]

I suggest you give a first stab at it and show us what you are doing.  That would help us see your table relationships better (please use inner/outer joins to make it clearer) and get a better idea of what you are trying to do.

Also, providing data examples like some of the other posts really help us help you get a good solution.

-Aaron

On 6/29/06, Penchalaiah P. <penchalaiahp(at)infics(dot)com> wrote:

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………………….