Hi,
From the query that you have given, I guess that you can use columns "LEADER_ID, FK_TESTCAT_ID , MEMBER_ID" for the joining conditions, because you are comparing all these column values to "1". So, by guesing this I am giving you this below query which uses inner Join. Try it out.
SELECT FROM PLM.FK_PROJECT_ID, TPM.FK_PROJECT_ID,PM.PROJECT_ID FROM PROJECT_LEAD_MAPPING PLM
INNER JOIN
TESTCAT_PROJECT_MAPPING TPM ON PLM.LEADER_ID = TPM.FK_TESTCAT_ID
INNER JOIN
PROJECT_MEMBER PM ON PM.MEMBER_ID = PLM.LEADER_ID
WHERE PLM.IS_ACTIVE = 1 AND TPM.IS_ACTIVE = 1 AND (PM.START_DATE <= '2012-4-17' AND PM.END_DATE > '2012-4-17')
This will give you values in column wise.
hope it helps.