select p.*,p.Price,p.Quantity as TotalPrice,c.Name as CategoryName from ( select Row_number() over (order by p.ProductId) as RowNo, p.*,p.Price*p.Quantity as TotalPrice,c.Name as CategoryName from Category as c inner join Product as p on c.ProductId=p.ProductId ) ProductCategory
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)