salut,

Select b.ExternalCode, a.*, c.CodStare

from tbl1 a,

(select * from tbl2 union select * from tbl2_hist) b,

where DataExecutiei = @Data

and a.CodMesajOut = b.MessageCode

and c.CodMesajOut = a.CodMesajOut

and c.CodStare = 32

and a.CodMesaj = 8

Order by a.CodMesaj

multumesc.

alex.