join in 3 tables

[meena latha]

Hi,
I need to take value from 3 tables.
Right now i am trying to pick value from 2 tables.
Below is the query for that

    
select a.location,a.address,a.description
from tableA a left outer join tableB b
on a.id = b.id
and b.num = ?
and a.orgid = 'mx'
order by a.location,b.description

now i need to pick the value from one more table whose num is the same as tableB 's num

 
select a.location,a.address,a.description,c.age
from (tableA a left outer join tableB b
 
on a.id = b.id
and b.num = ?
and a.orgid = 'mx')
 
left join tableC c 
on c.num = b.num
 
where a.type = 'value'
      and a.location = 'tx'
order by a.location,b.description

if i do this i am not getting any value for the age eventhough there is some value for that particular num.

what i all need is to select the age from tableC and display it.
Is there any other way of written this query.
thanks in advance.

[Purushoth Thambu]

You can try below syntax.

 
select a.location,a.address,a.description,c.age
from (select a.*, b.num from tableA a, tableB b
 where a.id = b.id(+)
and b.num = ?
and a.orgid = 'mx'
and a.type = 'value'
and a.location = 'tx'
) a, tableC c 
where c.num(+) = a.num
order by a.location,a.description
   

Nothing looks odd at your SQL. Some sample data will be really help ful.

[meena latha]

Thanks for the reply.
I just modified the query like this.

    
 
select a.location,a.address,a.description,
(select age from tableC where num=?)as age
from tableA a left outer join tableB b
on a.id = b.idand b.num = ?and a.orgid = 'mx'
order by a.location,b.description