Re: can any one solve this problem

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