hi this is my query im struct
select SUM(a.qty) as Qt, SUM(b.Dqty) as Qt1 from dbo.table1 a
left join dbo.table2 b on a.No=b.DNo where a.No='M1'
im getting output like this
I need output like this
Note: if Qt1 return Null then i need to show 1500 only for above example.
how to do?
View Complete Post