?I have the following query: SELECT (SELECT COUNT(*) FROM proverbs) AS Total , (SELECT COUNT(*) FROM proverbs WHERE NOT used IS NULL) AS Used
But I want something like: ? SELECT (SELECT COUNT(*) FROM proverbs) AS Total , (SELECT COUNT(*) FROM proverbs WHERE NOT used IS NULL) AS Used , (Total - Used) AS Free ?? ?But then I get: ? no such column: Total It can be done, because I have it done in the past, but obviously a little different. :'-( ?Anybody knows how it can be done?? -- Cecil Westerhof