How to compare two query result and create one dynamic colum

Saafia NM

9y807SQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saafia NM9y ago
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_fk,complaint_activity.complaint_fk,complaint_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

0
Esakki Muthu9y ago
Multipleways are there to implement this can you share your schema code , to understand your need better?
+1

complaint_fk	is_present
100	0
101	1
102	0
103	1