ზურა გამარჯობა, ამ ინფორმაციას ვიღებ TRITON\REVENUE

VIEW: VW_REVENUE_ALL_WITH_SSA_PID

SSA_PIROVNEBA_PN ეს ველია

SELECT TOP 100 PERCENT

       A.OP_DATE,

       A.PERIODI,

       A.PIROVNEBA,

       A.PIROVNEBA_PN,

       A.DAMSAQMEBELI_SK,

       A.DAMSAQMEBELI,

       A.GANACEMIS_SAXE,

       A.GANACEMIS_TANXA,

       A.DAKAVEBULI_TANXA,

       N.PIROVNEBA_PN AS SSA_PIROVNEBA_PN

FROM REVENUE_ALL AS A

LEFT OUTER JOIN dbo.NOT_SHOW N on N.PIROVNEBA_PN = A.PIROVNEBA_PN AND N.DateDeleted IS NULL

-- where N.PIROVNEBA_PN is NULL

order by A.PERIODI DESC

ზურა