I'm using Sybase IQ 12.5

I can execute the following query which is fine

select ROW_INSERT_DATE from ODS_MER.SBA_KARLILIK_SYSREC union
select ROW_INSERT_DATE from ODS_MER.BBA_KARLILIK_SYSREC

However if i add an order by clause I get an error. For instance I can
not execute the following query.

select ROW_INSERT_DATE from ODS_MER.SBA_KARLILIK_SYSREC union
select ROW_INSERT_DATE from ODS_MER.BBA_KARLILIK_SYSREC
order by ROW_INSERT_DATE

The error is: S0002(-143)(Sybase)(ODBC Driver)(Adaptive Server
IQ)Column not found: Column 'ROW_INSERT_DATE' not found

Any comments on this one?

metink (AT) hotmail (DOT) com (BugsBunny) wrote in message news:<d7c76161.0401140603.15d00bd8 (AT) posting (DOT) google.com>...
Sorry, came across this one pretty late. Try forcing a column heading
i.e. select ROW_INSERT_DATE as "Insert Date Column" from ... for each
query and then order by that heading.