How to compare two query result and create one dynamic colum

Question

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

Answer 1

Hi Lawrence,

 

I am not sure but please check below link may be this can help you.

 

Click Here to Check code

Thanks & Regard

Shambhoo :)