COUNT within WHERE statement?

[3dColor]

Can you place COUNT within a WHERE statement?

My query retreives image names from an Images Table for metro areas within a state.

SELECT imageState, imageName
FROM Images
WHERE imageState= #URL.state#

I have a checkbox on the page before the query asking them if they want to only include metro areas with photos, if it is checked then then I want to display only the metro areas with photos.

How can I check if a metro area has photos within it?

SELECT imageState, imageName
FROM Images
WHERE imageState= #URL.state#
      <cfif ISDefined("FORM.photos")>AND image.COUNT > 0</cfif>

 

[TonyGroves]

We'll need more information than that, for example table structures and expected results.