Ovako ti je najlakše:
Code:
SELECT DISTINCT t1.[Broj racuna], t2.operator, t2.iznos, t2.sumpdv
FROM
(SELECT [Broj racuna]
FROM
Table1) AS t1
LEFT JOIN
(SELECT [Broj racuna], operator, iznos, sumpdv
FROM
Table1) AS t2
ON t1.[Broj racuna] = t2.[Broj racuna]
Someone's sitting in the shade today because someone planted a tree a long time ago.