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