Hi All,

I'd like to convert the following select statement from T-SQL to PL/SQL. When I run the following query in SQL Server, it works great. When I try to run it in Oracle (with Oracle syntax) I get the following error:

"A table may be outer joined to only one other table"

The following is the select statement:

select a.attachmentid,v.serverid,s.AttachmentStatusID
from attachment a,
videoserver v,
AttachmentServer s
where a.videoid=v.videoid
and a.videoid =1
and s.attachmentid =* a.attachmentid
and s.serverid =* v.serverid

union all

select a.attachmentid,v.serverid,s.AttachmentStatusID
from attachment a,AttaccmentServer s,videoserver v
where s.attachmentid = a.attachmentid
and a.videoid=2
and s.serverid *= v.serverid
and a.videoid *= v.videoid

union all

select a.attachmentid,null,null
from attachment a
where a.videoid=2
and a.attachmentid not in (select s.attachmentid from AttaccmentServer s)
and a.videoid not in (select v.videoid from videoserver v)


Any help would greatly be appreciated.

- G