[Solved] How to filter twice using subquery? [closed]


I think you just need this. There is no need for the subquery.

SELECT 
        DISTINCT 
         T0.project_number_ext as ProjectNumber
        ,T0.status_desc as SDesc
        ,T0.Project_name as PName
    From trimergo.rpt_getProjectPOC T0
    WHERE T0.sproject_number IS NULL AND 
    ( T1.SDesc LIKE '10 - In Proposal%' OR T1.SDesc like '90-Lost Opportunity%' )

3

solved How to filter twice using subquery? [closed]