I have a table where I use 'unused' to signify that a record is not yet used. I want to know the number of unused records (but only if there are unused records) and the total number of records.
At the moment I implemented it like: SELECT * FROM ( SELECT 'Not used' AS Type , COUNT(*) AS NoUsed FROM quotes WHERE totalUsed == 'unused' UNION ALL SELECT 'Total' AS Type , COUNT(*) AS NoUsed FROM quotes ) WHERE NoUsed > 0 Is this correct, or is there a better way? -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users