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

Esakki Muthu · Answer

Multipleways are there to implement this can you share your schema code  to understand your need better?

Saafia NM · Answer

Query1: (select id as complaint_fk from complaint_dashboard where isClosed=1) ; Result 1: complaint_fk 100 101 102 103 Query 2: (select complaint_activity.complaint_fk from complaint_activity inner join complaint_dashboard on complaint_activity.complaint_fk = complaint_dashboard.id inner join complaint_status on complaint_activity.status = complaint_status.status and complaint_status.is_onsite_status=1 group by complaint_dashboard.workflow_fkcomplaint_activity.complaint_fkcomplaint_activity.status having (count(complaint_activity.id))>1 order by complaint_fk) Result 2: complaint_fk 101 101 103 103 Expecting : complaint_fk is_present 100 0 101 1 102 0 103 1