> The MSSQL on-line manual says:
>
> "when the SELECT statement includes a UNION operator, the column names or
> column aliases [in the order by clause] must be those specified in the
> first select list."
>
> This should fix your problemo.
>
> Regards,
> Anthony Geoghegan
> Lead Developer
> Ireland Film and Television Net
> 26 South Frederick Street
> Dublin 2
> Ireland
> Tel: +353 1 671 3664
> Fax: +353 1 671 0763
> Web: www.iftn.ie www.wow.ie
> mailto:[EMAIL PROTECTED]
>
> NOTICE:
> This communication is confidential. The copyright in this communication
> belongs to Ireland Film & Television Net (IFTN) or a third party.
>
> If you are not the intended recipient of this communication please delete
> and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
> If you are the intended recipient of this communication you should not
> copy, disclose or distribute this communication without the authority of
> IFTN.
>
> Any views expressed in this communication are those of the individual
> sender except where the sender specifically states those are of view of
> IFTN.
>
> Except as required by law IFTN does not represent, warrant, and/guarantee
> that the integrity of this communication has been maintained or that the
> communication is free of virus, interception or interference.
>
>
------------------------------------------------------------------------------
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.
