Brendan Tate
asked on
FROM Keyword not found where expected - Crystal Reports command object
When using a union as a command object in CRXI i'm getting an error 'FROM keyword not found where expected'. Oracle error 923
SELECT *, 'H2' AS Type FROM db.table1
WHERE TLC_CURRENT_FLAG = '1'
UNION ALL
SELECT *, 'H3' AS Type FROM db.table2
WHERE TLC_CURRENT_FLAG = '1'
UNION ALL
SELECT *, 'H4' AS Type FROM db.table3
WHERE TLC_CURRENT_FLAG = '1'
UNION ALL
SELECT *, 'H5' AS Type FROM db.table4
WHERE TLC_CURRENT_FLAG = '1'
UNION ALL
SELECT *, 'H6' AS Type FROM db.table5
WHERE TLC_CURRENT_FLAG = '1'ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER