Třídová akce

Kód:

19

Tělo:

Select
  SC.ID
From
  StoreSubCards SC
Where
  SC.Store_ID = :Store_ID and
  SC.Quantity <>
  Coalesce(
    (
      Select
        Sum(LSC.Quantity)
      From
        LogStoreContents LSC
          inner join
        LogStorePositions LSP
          on
        LSP.ID = LSC.Parent_ID
      Where
        SC.StoreCard_ID = LSC.StoreCard_ID and
        LSP.Store_ID = SC.Store_ID
    ), 0)

Generated by ABRA Software a.s. 27.10.2021 16:34:12