SELECT DISTINCT P.TITLE ,P.PROJECT_ID FROM PROJECT_MEMBER PM INNER JOIN PROJECT P ON PM.PROJECT_ID = P.PROJECT_ID LEFT JOIN PROJECT_LEAD_MAPPING PLM ON PLM.FK_PROJECT_ID = P.PROJECT_ID AND PLM.IS_ACTIVE = 1 WHERE ((PM.MEMBER_ID = 1) OR (PLM.LEADER_ID = 1)) AND P.STATUS = 4 AND PM.START_DATE <= '2012-4-17' AND PM.END_DATE > '2012-4-17'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)