Having a table A with one of the cols being STATE, and a table B with all the states listed in col b.State;
how can it will include in count output results 0 , for GROUP BY col A.State without any records?
I know how to use GROUP BY ALL, but is not usable in this case, when there is not any WHERE criteria.
Desire output should look like:
AL _______ 100
AK _______ 0
AZ _______ 3