Table : incident ---------------- incident_id usr_id item_id Inc_Date 10059926 191 61006 8-22-2015 10054444 222 3232 6-7-2015 Table: act_reg -------------- act_reg_id act_type_id incident_id usr_id act_type_sc 454244 1 10059926 191 ASSIGN 471938 115 10059926 191 TRAVEL TIME 473379 40 10059926 191 FOLLOW UP 477652 115 10059926 191 TRAVEL TIME 489091 504 10059926 191 ADD_ATTCHMNTS 477653 504 10054444 222 ADD_ATTCHMNTS
Parameter: @attach (value=1, Label=Yes & Value=0, Label=No)
Result (While I am selecting 'Yes' in dropdown) ---------------------------------------------- incident_id usr_id item_id 10059926 191 61006 10054444 222 3232
SELECT incident.incident_id,incident.usr_id,incident.item_id FROM incident where exists (How i can write query here to check the
act_type_sc=ADD_ATTCHMNTS is exists)