Este es un ejemplo de mi consulta...Como muestra l final el ORDER BY necesito ordenarla por ese campo, pero no esta en el SELECT
use mybase
Select P.ProvNombre as [Proveedor],
case when CC.CpCategoria=1 then
convert(nvarchar,CC.CpFechaComp,110)
when CC.CpCategoria=0 then
convert(nvarchar,CC.CpFechaComp,101)
end as [Fecha],
C.ComAbrev as [Comprobante],
CC.CpLetra as [Letra],
CC.CpPtoVenta as [PV],
CC.CpNumCom as [Numero],
'' as [Fecha de Vencimiento],
M.MonSimb as [Moneda],
(select count(*) from CCProVen
Where CpEmpresa = CC.CpEmpresa and
CpSuc=CC.CpSuc and
CpNi=CC.CpNi) as [Cuotas],
case when CC.CpTotal > 0 then
convert(nvarchar,Convert(money,abs(CC.CpTotal)),0)
else
''
end as [Debe],
case when CC.CpTotal < 0 then
convert(nvarchar,Convert(money,abs(CC.CpTotal)),0)
else
''
end as [Haber]
From CCPro as CC
INNER JOIN Proveedores as P ON P.ProvCod = CC.CpProv
INNER JOIN Comprobantes as C ON C.ComCod = CC.CpTipoComp
INNER JOIN Moneda as M ON M.MonCod = CC.CpMoneda
Group by P.ProvNombre,
CC.CpCategoria,
CC.CpFechaComp,
C.ComAbrev,
CC.CpLetra,
CC.CpPtoVenta,
CC.CpNumCom,
M.MonSimb,
CC.CpTotal,
C.ComSigno,
CC.CpEmpresa,
CC.CpSuc,
CC.CpNi
------------------------------------------------------------------------
union
------------------------------------------------------------------------
Select P.ProvNombre as [Proveedor],
case when O.OpCategoria = 1 then
convert(nvarchar,O.OpFechaPago,110)
when O.OpCategoria=0 then
convert(nvarchar,O.OpFechaPago,101)
end as [Fecha],
C.ComAbrev as [TIPO],
'' as [Letra],
'' as [PV],
O.OpNumPago as [Numero],
'' as [Fecha Vencimiento],
M.MonSimb as [Moneda],
'' as [Cuotas],
case when (select CCPro.CpTotal from CCPro
where CCPro.CpEmpresa = CC.CpEmpresa and
CCPro.CpSuc = CC.CpSuc and
CCPro.CpNi = CC.CpNi) < 0 then
convert(nvarchar,Convert(money,abs(O.OpTotal)),0)
else
''
end as [Debe],
case when (select CCPro.CpTotal from CCPro
where CCPro.CpEmpresa = CC.CpEmpresa and
CCPro.CpSuc = CC.CpSuc and
CCPro.CpNi = CC.CpNi) > 0 then
convert(nvarchar,Convert(money,abs(O.OpTotal)),0)
else
''
end as [Haber]
From OrdenPago as O
INNER JOIN Proveedores as P ON P.ProvCod = O.OpProv
INNER JOIN Moneda as M ON M.MonCod = O.OpMoneda
INNER JOIN Comprobantes as C ON C.ComCod = O.OpComp
INNER JOIN OrdenPagoComp as OPC on OPC.OpNi = o.OpNi
INNER JOIN CCpro as CC on CC.CpNi = OPC.CpNi
-------------------------------------------------------------------------
order by CC.CpNi