Home » RDBMS Server » Server Administration » Re: SQL Statement with Null return -- URGENT!!!!
Re: SQL Statement with Null return -- URGENT!!!! [message #375041] Fri, 20 July 2001 06:58
Matthew
Messages: 20
Registered: July 2001
Junior Member
I would consider using an outer join.
like so:

select ......
from table1, table2, table3, table4
where table1.id = table2.id
and table2.id = table3.id
and table3.id = table4.id(+)

Report message to a moderator

Previous Topic: sql query
Next Topic: Re: SQL Statement with Null return -- URGENT!!!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 21:18:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.