Salut, am nevoie de ajutor in urmatoarea problema: Am interogarea:

SELECT dbo.PARTENERI.NUME, dbo.ANTET_FACTURI.ID AS aidi, dbo.ANTET_FACTURI.NUMECLIENT, dbo.ANTET_FACTURI.NRDOC, dbo.ANTET_FACTURI.DATA, dbo.ANTET_FACTURI.MONEDA,dbo.ANTET_FACTURI.SERIECARD,
(SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)) AS SUMA,
COALESCE((SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)) -
(SELECT SUM(VALOARE) FROM dbo.CHITANTECL WHERE (ID_ANTET_FACTURA = dbo.ANTET_FACTURI.ID)),
(SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID))) AS REST
FROM dbo.ANTET_FACTURI INNER JOIN dbo.PARTENERI ON dbo.ANTET_FACTURI.ID_PARTENER = dbo.PARTENERI.ID
WHERE
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
ORDER BY dbo.ANTET_FACTURI.NRDOC

Cele 2 tabele sint de forma:
CREATE TABLE [dbo].[ANTET_FACTURI](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[NRDOC] [decimal](18, 0) NULL,
[DATA] [smalldatetime] NULL,
[ID_PARTENER] [decimal](18, 0) NULL,
[NUMECLIENT] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MONEDA] [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TVA] [money] NULL,
[ID_USER] [decimal](18, 0) NULL,
[MOMENT] [datetime] NULL,
[MOD_PLATA] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SERIECARD] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VALIDA] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

si: