Tengo esto :
Código:
SELECT C.NOMBRE as n,
E.codexp AS numexp,
E.refcomp as refcomp,
E.fnotif AS fnotif,
E.ffinexp as fcierre,
E.finfinicolab as d,
E.finffincolab as e,
R.totpagosaut as imp,
R.totaldesc as descont,
sum(T.diasfac) as dias,
A.edad as edad,
sum(H.Hvardesc) as honor,
sum(H.honormedcol) as honormed,
sum(H.tothonor) - sum(h.hvardesc) as honorfij
FROM expedientes E
inner join resumenpagos R on R.codexp = E.codexp
inner join
(SELECT top 1 diasfact , CODEEXP FROM tratamientos )
T on
T.codexp = E.codexp
inner join asegurados A on A.codaseg = E.codaseg
inner join compania C on C.codcompania = E.compaseg
left join honorcias H on H.codexp = E.codexp
group by C.NOMBRE, E.codexp, E.refcomp, E.fnotif, E.ffinexp,
E.finfinicolab, E.finffincolab,
R.totpagosaut, R.totaldesc, A.edad
ORDER BY expedientes.compaseg
Me da error en que no reconoce select ( la que viene despues del inner join ).
Hay alguna forma "extraña" de ponerlo o algo similar ???????