İki tabloyu birleştirdim nerede hata yapıyprım
SELECT MAX(STLINE.STOCKREF) AS D, MAX(DISTINCT CLCARD.DEFINITION_) AS UNVAN
FROM dbo.LG_321_01_STLINE AS STLINE WITH (NOLOCK) INNER JOIN
dbo.LG_321_ITEMS ON STLINE.STOCKREF = dbo.LG_321_ITEMS.LOGICALREF INNER JOIN
dbo.LG_321_CLCARD AS CLCARD WITH (NOLOCK) ON STLINE.CLIENTREF = CLCARD.LOGICALREF
WHERE (STLINE.CANCELLED = 0) AND (STLINE.LINETYPE <> 2) AND (STLINE.TRCODE = 1)
GROUP BY STLINE.STOCKREF,dbo.LG_321_ITEMS.CODE)
AS ALIS_321 on LG_211_ITEMS.CODE = CODE
SELECT MAX(STLINE.STOCKREF) AS D, MAX(DISTINCT CLCARD.DEFINITION_) AS UNVAN
FROM dbo.LG_321_01_STLINE AS STLINE WITH (NOLOCK) INNER JOIN
dbo.LG_321_ITEMS ON STLINE.STOCKREF = dbo.LG_321_ITEMS.LOGICALREF INNER JOIN
dbo.LG_321_CLCARD AS CLCARD WITH (NOLOCK) ON STLINE.CLIENTREF = CLCARD.LOGICALREF
WHERE (STLINE.CANCELLED = 0) AND (STLINE.LINETYPE <> 2) AND (STLINE.TRCODE = 1)
GROUP BY STLINE.STOCKREF,dbo.LG_321_ITEMS.CODE)
AS ALIS_321 on LG_211_ITEMS.CODE = CODE
Son düzenleme: