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