Combine two queries into columns if join breaks grouping and union combines into rows
how do I combine the results of these queries into columns? join is not suitable, because then in the on condition you will need to compare the id and the grouping will be broken, and union joins into strings. I want to get 4 columns in the result set. is it possible to modify the union operator in some way?
how to combine two queries into columns if join breaks grouping and union combines into rows
how do I combine the results of these queries into columns? join is not suitable, because then in the on condition you will need to compare the id and the grouping will be broken, and union joins into strings. I want to get 4 columns in the result set. is it possible to modify the union operator in some way?
how to get non-zero field records as a result of a query and at the same time get the number of all records in the table, regardless of their value
I want to take into account all records even with NULL values when calculating the count for num_zaprosa and num_otveta, but not show them in the result set.
Is it possible to do this?
here is my code, but it did not help me solve my problem: