RE: Null in SQL select union

[CWilt@xxxxxxxxxxxx]

Titus,

What are you trying to do?  The example you posted doesn't make any sense.

Charles


> -----Original Message-----
> From: Titus Kruse [mailto:t_kruse@xxxxxxxxx]
> Sent: Thursday, March 25, 2004 6:08 AM
> To: Midrange L
> Subject: Null in SQL select union
> 
> 
> Hi!
> 
> I want to execute two queries combined with UNION. In columns 
> without a
> value, I wand to have null for default. When sorting the 
> resulting query,
> rows with null in group-fields and a value in result-fields 
> should be placed
> after those with a value in group-fields.
> 
> Here is my example:
> 
> SELECT type, color, NULL AS number FROM cars
> UNION SELECT NULL AS type, NULL AS color, COUNT(*) FROM cars
> GROUP BY type
> ORDER BY type, color
> 
> But this will not be executed because of errer "NULL is not a 
> column of
> cars".
> 
> How do I specify a null-value in a SELECT-clause?
> 
> 
> 
> Titus Kruse
> Software-Entwicklung IBM iSeries
> ESW Software Warda KG (GmbH & Co.)
> Telefon: +49.40.682893.22
> Telefax: +49.40.682893.28
> E-Mail: t_kruse@xxxxxxxxx
> Web: www.esw-kg.de
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>