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'
Loading
SUNIL GUTTAPosted Mar 7, 2014, 6:36 AM
May be u can use DISTINCT function in select so you can eliminate duplicates
Regards
kiran TPosted Mar 6, 2014, 10:59 PM
selva kumarPosted Mar 6, 2014, 7:31 AM
selva kumarPosted Mar 6, 2014, 6:35 AM
kiran TPosted Mar 6, 2014, 6:30 AM
group by
t.Branch,
t.Brand,
t.Dimension,
t.Primary_Quantity
,t.Transferred_Stock,
r.Transferred_Stock ,
(t.Mon+'-'+t.Yr)
end
selva kumarPosted Mar 6, 2014, 6:30 AM
selva kumarPosted Mar 6, 2014, 6:27 AM
it is not contained in either an aggregate function or the GROUP BY clause.
kiran TPosted Mar 6, 2014, 6:17 AM