Re: Invalid column name

Mark C. Stock wrote:

>
> 1) post the statement that causes the error
> 2) you probably need to order by column position, not column name, since
> you're using set operators

Simply "order by table1.col1" causes this error, or any other column of table1.
But I can't use column position because it could change. I 've put a.* or c.* because there are too many columns... Received on Fri May 20 2005 - 16:43:34 CDT