SQL Query

Any ideas why this isn't working:

SELECT
`Item Type`,
COUNT(*),
FROM Stock
WHERE `Use Commenced By` = ""
GROUP BY `Item Type`

Code (markup):

But this works fine:

SELECT
`Item Type`,
COUNT(*),
FROM Stock
GROUP BY `Item Type`

Code […]

See original post by invalid@example.com (NITRO23456)

Leave a Reply