i have 2 table with some 100 entries, of which some say 70 entries have images in them, these images r stored in different table
is it possible to get result like
image 70 30
in a single query???
i am running query like
SELECT imagetype.image_type, count( docs.ids ) AS 'Image_present' FROM docs, imagetype WHERE docs.ids = imagetype.id AND imagetype.image_type = "Image1" GROUP BY imagetype.image_type
and i am getting result as
now i want the count without images it's 30 here, what to add in the query??
thanx in advance