Sql Help..

[4Vikram]

Bhaiyya i have this query and when executed using left join i am getting these many rows...

 

when executed with inner join getting .. 123,133,503

 

 

So my concern is before joining [dbo].[TransRM_EmailTemplate] i had only these many rows... 34,849,586 

 

 

why it is coming more anedi ardam aitaledu...  ipudu left join chesindi correst aa leka inner join. if yes why anedi my question..

 

Appreciate any help, thanks in advance

 

select * 

from RMReporting_Stg.dbo.[Open] as dt

join RMReporting_Stg.dbo.[Send] as sd

       on dt.SendID = sd.SendID 

join [dbo].[TransRM_EmailTemplate] as ET

       on sd.EmailName = ET.EmailName

left join TransactionalRMDB.dbo.TransRM_ProgramMetaData as md

on sd.EmailName = md.EmailName --210,436,894 

[Silver_mani]

read abt joins first ...

[Suhaas]

[4Vikram]

LTT

[dotnetrockz]

left join ante meaning adhi ur joing ur parent table to a child table which will pick all rows from child table...

[cheguveera]

 

Bhaiyya i have this query and when executed using left join i am getting these many rows...

 

when executed with inner join getting .. 123,133,503

 

 

So my concern is before joining [dbo].[TransRM_EmailTemplate] i had only these many rows... 34,849,586 

 

 

why it is coming more anedi ardam aitaledu...  ipudu left join chesindi correst aa leka inner join. if yes why anedi my question..

 

Appreciate any help, thanks in advance

 

select * 

from RMReporting_Stg.dbo.[Open] as dt

join RMReporting_Stg.dbo.[Send] as sd

       on dt.SendID = sd.SendID 

join [dbo].[TransRM_EmailTemplate] as ET

       on sd.EmailName = ET.EmailName

left join TransactionalRMDB.dbo.TransRM_ProgramMetaData as md

on sd.EmailName = md.EmailName --210,436,894 

 

pm to loveindia

[4Vikram]

pm to loveindia

PM ed but no response

[ghazni]

it may be getting some duplicates... when u join make sure ON what else  u need to join....