A SubQuery is showing the result. but the same query after joins not showing output. please correct me.
Below query is giving result:
SELECT p.proposal.proposalNo
FROM data p
WHERE p.type_='Policy' and p.proposal.proposalNo
IN (select raw t.taskAttrs.proposalNumber from data t where t.type_='Task' )
Below query is not giving result after join
SELECT p.proposal.proposalNo FROM data ta
INNER JOIN data p ON
ta.proposalNo.proposalNumber =p.proposal.proposalNo
WHERE ta.type_='Task' AND p.type_='Pol'