Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (SELECT tw__Towar.tw_Id, tw__Towar.tw_Nazwa AS [Nazwa Towaru], tw__Towar.tw_Symbol AS [Symbol Towaru], tw__Towar.tw_PodstKodKresk AS [Kod Kreskowy],
- tw_Cena.tc_CenaNetto0 AS [Cena Netto], tw_Cena.tc_CenaBrutto1 AS [Cena Brutto], sl_StawkaVAT.vat_Stawka AS [Stawka VAT],
- sl_GrupaTw.grt_Nazwa AS [Grupa Towarowa],tw_KodKreskowy.kk_Kod AS [dodatkowy] , (st_stan - st_StanRez) AS [ilosc]
- FROM tw__Towar INNER JOIN
- tw_Cena ON tw__Towar.tw_Id = tw_Cena.tc_IdTowar INNER JOIN
- sl_GrupaTw ON tw__Towar.tw_IdGrupa = sl_GrupaTw.grt_Id INNER JOIN
- sl_StawkaVAT ON tw__Towar.tw_IdVatSp = sl_StawkaVAT.vat_Id AND tw__Towar.tw_IdVatZak = sl_StawkaVAT.vat_Id INNER JOIN
- tw_KodKreskowy ON tw__Towar.tw_Id = kk_IdTowar
- INNER JOIN tw_Stan ON tw__Towar.tw_Id = tw_Stan.st_TowId
- WHERE tw_zablokowany=0
- AND tw_usuniety = 0
- AND (st_stan - st_StanRez) > 0 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement