I have a simple table called Animals.
AnimalType , Number_on_Farms
Cat , 1
Dog , 4
Pig , 5
I want a SQL Query which will show a SINGLE field row output of the total of "Cats" and "Dogs" only.
Output should simply be;
My problem is that I find I need to do a second query in order to get a single row output - otherwise I end up with a total for cats and a separate row for dogs. I just want one row output.