salut.
as vrea sa imi spuneti dc exista posibilitatea ca, intr-un sg query, sa fac ceva de genul urmator( ce este intre [[[ si ]]] reprezinta dilema mea,nu stiu forma sub care as putea nest-ui acel select ca parte din selectul principal):
select
nrcontract,appid,rezolutie,
comentarii,
[[[ SELECT max(c) FROM
(SELECT dataplata AS c FROM history
UNION
SELECT lastphonedate AS c FROM history) as t2 ]]]
,max(contactno)+1 as MaxC,lastmodifiedby,lastmodifydate from history
where nrcontract='1' group by ....