19-03-2012, 07:56 AM
وعليكم السلام
جرب التالي
جرب التالي
PHP كود :
with a as
( select guid, sum(Name.No) as Total
from Clients
group by Name.guid )
select *, a.Total
from Products t
inner join a
on t.GUID=a.Guid

