I work on sql server 2012 i face issue ican't replace (where exists)
by inner join
so How to do it
SELECT pr.partid
from
parts.Nop_Part pr with(nolock)
inner join extractreports.dbo.RequiredPartsPL rp with(nolock) on rp.partid=pr.partid
inner join Parts.Nop_PackageAttribute pa WITH(NOLOCK) on pa.packageid=pr.packageid
inner JOIN dbo.Core_DataDefinitionDetails dd WITH(NOLOCK) ON pa.[Key] = dd.ColumnNumber --and dd.acceptedvalueid=64
where
exists(select 1 from extractreports.dbo.getrelatedkeyandvaluepackage g where g.Featureid=dd.acceptedvalueid and g.valueid=pa.value )
group by pr.partid
so how to replace statement above by inner join instead of using where exists
statment