SQL & PL/SQL

Hello all

I dont have a idea how to write this Select. But this need to be in SQL not PL/SQL .

I want recive answer Yes or No from two select in one query how i can do that ?

(select decode(count(1),0,'No','Yes') from zia_all_diagnoses dgs where dgs.mse_mse_id = ZiaVMessages_EO.MSE_ID and dgs.ccn_class_codcontain_case_type = 'DV0002')

(SELECT DECODE (COUNT (1), 0, 'No', 'Yes')    FROM zia_all_diagnoses dgs   WHERE dgs.cse_cse_id = SgrVcases_EO.CSE_ID     AND dgs.ccn_class_codcontain_case_type = 'DV0002')

The result need to be
If someone of query return yes then i need to get Yes , if both ar No then No

Thanks

ID.

Edited by: 1D10T on Oct 29, 2012 8:04 AM