Skip to content
Advertisement

What is the best way to combine these two queries

I keep getting mysql errors when I try to write joins or unions combining these two queries. field1A and field1B are the conditions I am trying to count.

and

I am sure there is a more elegant way than running both queries and adding the totals together.

Advertisement

Answer

You can get it from single select as follows.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement