left outer join ( =*)

[sathya24]

Hi
When i am useing left outer join result is without null records(null value from table_c).But 2nd method with out outer join result is with null record.I want null records,but i want to use outer join.How?
1.select * from table_a a
inner join table_b b on a.company_no = b.company_no
left outer join table_c c on b.company_no = c.company_no
and a.com_id=c.com_ id
and c.contact_id = a.contact_id

2.
select * from table_a a, table_b b, table_c c
where
and b.company_no *= c.company_no
and a.contact_id *= c.contact_id
and c.com_id =* a.com_id

reagrds,
Sat.

[iburyak]

Try this:

select *
from table_a a
left outer join table_b b on a.company_no = b.company_no
left outer join table_c c on b.company_no = c.company_no
and a.com_id=c.com_ id
and c.contact_id = a.contact_id