Re: Null in SQL select union

I'm a little confused also.  Suppose your table had the following data:
....+....1....+....2....+.
TYPE  COLOR         NUMBER
       R                 1
 A                       7
 X     B                 0
 C     D                 2
********  End of data  ***
What result would you expect from your query?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Titus Kruse" <t_kruse@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/25/2004 06:08 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange L" <midrange-l@xxxxxxxxxxxx>
cc

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.