Skip to content
Advertisement

How to compare counts from subselect?

I want to compare the count between two tables. Or more to say, output if the count from table1 is greater than from table2:

(real world selects are much more complex, but same structure)

Result: Unknown column 'c1' in 'field list'

How can I actually evaluate the counts?

Advertisement

Answer

Name the columns:

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