How to compare two query result and create one dynamic colum

Dec 11 2017 9:07 AM

I have two mysql query result, both result having same colum based on some conditions.

I have to check the value in the first result column is present in the second result column. If it is there i have to create new column value as 1, else it is 0. How can i do this

Answers (2)

SQL Query or Linq query to get number of Events per Day.

SQL query