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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.