Titus, I would cod eit as follows: >SELECT type, color, 0 AS number, "A" AS Code FROM cars >UNION SELECT type, color, COUNT(*), "B" AS Code FROM cars >GROUP BY type, color >ORDER BY type, color, Code But I think you do not the first query at all. Regards, Carel Teijgeler. *********** REPLY SEPARATOR *********** On 25-3-04 at 12:08 Titus Kruse wrote: >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?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.