ORA-01417: a table may be outer joined to at most one other table

From: sandyb <member_at_dbforums.com>
Date: Mon, 23 Dec 2002 12:51:57 +0000
Message-ID: <2312390.1040647917_at_dbforums.com>

Hi there,

I have the folowing query executed in QRACLE 9i. and I get the error message: ORA-01417: a table may be outer joined to at most one other table

The query:

select

DocumentTypeElement.documentTypeId as documentTypeId,
DocumentTypeElement.documentTypeElementId as documentTypeElementId,
DocumentTypeElement.name as name,
DocumentTypeElement.isMandatory,

DocumentElement.documentElementId,
Document.documentId,
Document.name as documentName,
DocumentElement.valueText,
DocumentElement.valueLargeText,

DomainElement.valueText as domainElementValueText,
DomainElement.valueLargeText as domainElementValueLargeText,
DomainElement.extention as domainElementExtention,
DocumentElement.tsCreated as tsCreated,
DocumentElement.userIdCreated as userIdCreated,

DocumentElement.tsChanged as tsChanged,
DocumentElement.userIdChanged as userIdChanged, DocumentTypeElement.domainId,
DocumentTypeElement.label,
DocumentElement.domainElementId,

Domain.domainId,
Domain.length as Length,
Domain.name as domainName,
Domain.datatypeId as dataTypeId,
Domain.hasDomainValues,
DomainElementDomain.length as domainElementDomainLength,

DomainElementDomain.name as domainElementDomainname, DomainElementDomain.datatypeId as domainElementDomainType, DomainElement.extention as domainElementDomainExtention From
Template, DocumentType, Document, DocumentVersion, TemplateDocumentTypeElement, DocumentTypeElement, DocumentElement, DomainElement, Domain as DomainElementDomain, Domain where
(template.templateId = 2) and (((Document.tsStart <= '2002-12-23 11:08:28.0' and Document.tsEnd is null)

or (Document.tsStart <= '2002-12-23 11:08:28.0' and Document.tsEnd

>='2002-12-23 11:08:28.0' ))

or (Document.tsStart >= '2002-12-23 11:08:28.0')) and documentType.documentTypeId = template.documentTypeId and Document.documentTypeId = DocumentType.documentTypeId and Document.tsStart < SYSDATE and ( Document.tsEnd is null or Document.tsEnd > SYSDATE)
and documentVersion.documentVersionId =
Document.publishingDocumentVersionId
and DocumentVersion.documentId = Document.documentId and TemplateDocumentTypeElement.templateId (+)= template.templateId and DocumentType.documentTypeId (+)= DocumentTypeElement.documentTypeId and DocumentTypeElement.documentTypeElementId (+)= templateDocumentTypeElement.documentTypeElementId

and DocumentElement.documentTypeId (+)=
DocumentTypeElement.documentTypeId
and DocumentElement.documentTypeElementId (+)=
DocumentTypeElement.documentTypeElementId
and DocumentElement.documentId (+)= Document.documentId
and DocumentElement.documentVersionId (+)=

DocumentVersion.documentVersionId
and DomainElement.domainId (+)= DocumentElement.domainId and DomainElement.domainElementId (+)= DocumentElement.domainElementId and DomainElementDomain.domainId (+)= DomainElement.domainId and Domain.domainId (+)= documentTypeElement.domainId order by Document.defaultOrder, Document.tsstart desc , Document.documentId, TemplateDocumentTypeElement.displayOrder

Can someone help me!
Friendly regards,
Sandy

--
Posted via http://dbforums.com

Received on Mon Dec 23 2002 - 13:51:57 CET