selva kumar

selva kumar

  • NA
  • 557
  • 189k

Join does not working properly?

Mar 6 2014 5:57 AM
when joining two tables using join function result displays two times...Here is my query can anyone suggest me...

Select t.Branch,t.Brand,t.Dimension,t.Primary_Quantity,t.Transferred_Stock,r.Transferred_Stock as AvailableStock,(t.Mon+'-'+t.Yr) as [Year]
From Alloy_Stock_Allocation t
join Alloy_Stock_Allocation_Ref r on t.Brand=r.Brand and t.Yr=r.Yr and t.Mon=r.Mon
Where t.Yr='2014' and t.Mon='Feb'


Answers (8)