SELECT T.PROJECT_ID , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME FROM PA_TASKS T WHERE TASK_ID IN (SELECT TASK_ID FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA WHERE T.PROJECT_ID = PPAA.PROJECT_ID AND PPAA.PROJECT_ASSET_ID = 0)
View Text - HTML Formatted
SELECT T.PROJECT_ID , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME FROM PA_TASKS T WHERE TASK_ID IN (SELECT TASK_ID FROM PA_PROJECT_ASSET_ASSIGNMENTS PPAA WHERE T.PROJECT_ID = PPAA.PROJECT_ID AND PPAA.PROJECT_ASSET_ID = 0)