Daniel De Campos

SELECT A. Categoryname AS Categoría, B. Productname AS Producto, SUM(C.unitprice * C. Qty) AS VentaBruta, SUM(C. Discount) Descuento, SUM((C.unitprice * C. Qty)-C. Discount) AS VentaNeta FROM Sales. OrderDetails AS C, Production. Categories AS A,...

Select a.productid, a.productname, b.unitprice, case when a.unitprice = b.unitprice then b.qty when a.productid = b.productid then b.qty else null end as qty from Production.Products as a, sales.OrderDetails as b

SELECT Cpa , Nombre_Calle , DECODE(MOD( Desde, 2), 1, Desde) DESDE , DECODE(MOD( Hasta, 2), 1, Hasta) HASTA FROM Tabla