Re: SQL query re unions and nulls

Andrew Thornberry wrote: > > I don't see the problem. > > select a,b,c,NULL > from x > where ... > union > select a,b,NULL,d > from x > where ...> . > . > . > > This works fine for me with Sybase. You may have problems when you are > doing a select into though as it complains about NULL table columns. > > Andrew But it doesn't with Informix because select null, mycol from mytable; complains about the NULL - Informix doesn't recognise it as a keyword in that context, unfortunately. My previous posting works until Informix get around to implementing more of the standards. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.