Hey folks :)
I'm trying to write a simple UNION query, between two dynamically created
select queries.
Based on the feilds that the user entered in the previous form, the SQL
statement's WHERE clauses are created.
Basically, I want to pull data from the current Employee Info table, and the
Employee History table, for a report.
However, the user has the option of Ordering the report either by name, or
by Absence Type.
When I stick the Order By statement at the end of the second Select clause,
Oracle returns the error:
"[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: invalid column name "
The column names Name and Reason *are* present in both tables. I tried to
qualify these columns by using empinfo.name and empinfo.reason, but this has
not helped.
Do any of you have a sample SQL statement that includes UNION and an ORDER
BY clause?
:-)
<CFIF IsDefined('ordervalue')>
<CFIF ordervalue EQ "Name">
ORDER BY empinfo.Name
<CFELSEIF ordervalue EQ "Absence">
ORDER BY empinfo.Reason
</CFIF>
</CFIF>
(If order value is not selected, then the resulting recordset will be sorted
according to Employee ID.)
-Gel
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.