Skip to content

Instantly share code, notes, and snippets.

@kwmiebach

kwmiebach/pack.sql

Created December 27, 2024 14:44
Show Gist options
  • Save kwmiebach/12b6b98f480d03fbc8bc1e4f7cdb0d8b to your computer and use it in GitHub Desktop.
Save kwmiebach/12b6b98f480d03fbc8bc1e4f7cdb0d8b to your computer and use it in GitHub Desktop.
Download ZIP
pack tmp
Raw
pack.sql
select
a.Artikelnummer,
a.ArtBruttoGewicht,
a.ArtOptimaleFertigungsmenge1,
p.PosBezeichnung1,
p3m.PosMenge1
/* p.* */
from cis.Vorgang v
left join cis.Position p
ON v.InterneVorgangsnummer = p.InterneVorgangsnummer
left join cis.Position3Menge p3m
ON v.InterneVorgangsnummer = p3m.InterneVorgangsnummer
left join cis.Artikel a
ON p.InterneArtikelnummer = a.InterneArtikelnummer
WHERE v.VorNummer = '873070'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment