| mojaSymfonia FORUM https://forum.mix-soft.pl/ |
|
| Kraj kontrahenta z SQL https://forum.mix-soft.pl/viewtopic.php?f=2&t=9916 |
Strona 1 z 1 |
| Autor: | ciezkitemat [ 2021-04-30, 13:08 ] |
| Tytuł: | Kraj kontrahenta z SQL |
Cześć, wyciągam sprzedaż po towarach takim kodem jak poniżej. Chciałbym do tego dorzucić kraj kontrahenta. Znalazłem niby w SSCommon.STElements kraje, ale nijak nie mogę mojego zapytania połączyć poprawnie z tą tabelą. Co by zmienić w kodzie, by otrzymać także kraj kontrahenta? Kod: SELECT DKH.Shortcut as KHkod, DK.kod as numer, US.LoginName as users, DK.data, DP.kod as TWkod, DP.ilosc, DP.wartNetto as netto, DP.wartVAT as VAT, DP.wartNetto + DP.wartVAT as brutto FROM HM.DK as DK LEFT JOIN SSCommon.STContractors as DKH ON DK.khid = DKH.id LEFT JOIN HM.DP as DP ON DP.super = DK.id LEFT JOIN SSCommon.STUsers as US ON US.id = DK.createdBy WHERE dk.data >= @a0 AND dk.data <= @a1 AND DK.typ = 0 AND DK.bufor = 0 AND DK.anulowany = 0 |
|
| Autor: | rafal [ 2021-04-30, 14:23 ] |
| Tytuł: | Re: Kraj kontrahenta z SQL |
Kod: SELECT DKH.Shortcut as KHkod, DK.kod as numer, US.LoginName as users, DK.data, DP.kod as TWkod, DP.ilosc, DP.wartNetto as netto, DP.wartVAT as VAT, DP.wartNetto + DP.wartVAT as brutto, adr.Country FROM HM.DK as DK LEFT JOIN SSCommon.STContractors as DKH ON DK.khid = DKH.id LEFT JOIN HM.DP as DP ON DP.super = DK.id LEFT JOIN SSCommon.STUsers as US ON US.id = DK.createdBy LEFT JOIN SSCommon.STPostOfficeAddresses adr ON adr.id = DK.khadid WHERE dk.data >= @a0 AND dk.data <= @a1 AND DK.typ = 0 AND DK.bufor = 0 AND DK.anulowany = 0 |
|
| Autor: | ciezkitemat [ 2021-05-04, 11:29 ] |
| Tytuł: | Re: Kraj kontrahenta z SQL |
Działa, dzięki. |
|
| Strona 1 z 1 | Strefa czasowa UTC+1godz. [letni] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|