You will need to pass through a temporary cursor:
SELECT * FROM TableA WHERE NOT DELETED() INTO CURSOR curTemp
SELECT * FROM curTemp;
INNER JOIN TableB ON curTemp.PK = TableB.FK;
INNER JOIN TableC ON curTemp.PK = TableC.FK
HTH
>Dear Sylvain, I want to filter out deleted record from main source table only. The other two ones, also can contain deleted records, but data of these records must be visible in query result.