How to use inner join instead of left join on query below in case of d

ahmed elbarbary

4y1.1k

I work on sql server 2014 I need to use inner join instead of left join
and update Haschemical i case of exist by haschemical or No in case of not exist
on statement below

i need to use inner join instead of left join because data is very big on table
ExtractReports.dbo.FinalComplanceDataDelivery may be 20 million so query take too much time to execute

so How to do that Please ?

update r set r.HasChemical=case when cm.partid is not null then 'HasChemical' else 'No' end
     from ExtractReports.dbo.FinalComplanceDataDelivery r with(nolock)
     left join 
     Parts.ChemicalMaster cm with(nolock) on cm.partid=r.partid

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anoop Kumar Sharma4y ago
Hi Ahmed,

Your query seems to be good but in case you want to use inner join then you need to do it in two steps:
First, update the HasChemical column with the value 'No' and then use the inner join to update the HasChemical column with the 'HasChemical' text.
0
Srinivasan Ramamoorthi4y ago
You can check this link https://stackoverflow.com/questions/9894353/update-query-with-inner-join-between-tables-in-2-different-databases-on-1-server
0