Hi,
I have Three tables A,B ,C
i've to get recors frm B & C based on a value from A..my algorithm is somewhat like this
if A.Type = 'x' then
select B.Name,B.Age FROM B Where B.Code = A.Code
else if A.Type = 'y' then
select C.Name,C.Address From C where C.Code = A.Code
how could i write a single query for this..the main problem is in getting multiple fields from B and C...Can anyone help me?
Thanks
nitha
I have Three tables A,B ,C
i've to get recors frm B & C based on a value from A..my algorithm is somewhat like this
if A.Type = 'x' then
select B.Name,B.Age FROM B Where B.Code = A.Code
else if A.Type = 'y' then
select C.Name,C.Address From C where C.Code = A.Code
how could i write a single query for this..the main problem is in getting multiple fields from B and C...Can anyone help me?
Thanks
nitha