on 07-05-2011 3:58 PM
Hi Experts,
Please help.
When I ran this query, I got a message saying "SQL Command not properly ended". What might be the cause of this error?
In the result field, I have displayed T1.UNIQUE_DOC_NAME, T2.LOCAL_REG_GLB_OBJECT_NAME.
(SELECT <%RESULTS%>
FROM
<%SCHEMA%>.FCI_AUCT_AUCTION_EVENT T1, <%EXT_TABLE(contracts.Contract)%> T2
WHERE
T1.CONTEXTID = <%CONTEXT(contracts.Contract)%> AND T1.OBJECTID = T2.PARENT_OBJECT_ID) TT1
LEFT OUTER JOIN
(SELECT OPT_IN_AGR_OBJECT_ID AS CONTRACT_OBJECT_ID, COUNT(OPT_IN_AGR_OBJECT_ID) AS AGR_COUNT
FROM
<%EXT_TABLE(contracts.Contract)%>
GROUP BY OPT_IN_AGR_OBJECT_ID) OPT_IN
ON TT1.OBJECTID = OPT_IN.CONTRACT_OBJECT_ID
<%ORDERBY%>
Thanks in Advance.
Sharmele.
I have found the result.
Actually I was trying to Left Outer join the entire query including the select statement.
If I queried as
SELECT <%RESULTS%>
FROM
(
<%SCHEMA%>.FCI_AUCT_AUCTION_EVENT T1
LEFT OUTER JOIN
(SELECT OPT_IN_AGR_OBJECT_ID AS CONTRACT_OBJECT_ID, COUNT(OPT_IN_AGR_OBJECT_ID) AS AGR_COUNT
FROM
<%EXT_TABLE(contracts.Contract)%>
GROUP BY OPT_IN_AGR_OBJECT_ID) OPT_IN
ON T1.OBJECTID = OPT_IN.CONTRACT_OBJECT_ID
)
<%ORDERBY%>
It would have worked fine.
Thanks,
Sharmele.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.