SELECT
Versand.lvPicklistenposition.kPickliste AS 'Pickliste',
Versand.lvPicklistenposition.cBestellNr AS 'Auftragsnummer',
Versand.lvPicklistenposition.cLieferscheinNr 'Lieferscheinnummer',
Versand.lvPicklistenposition.cAuftragArtNr AS 'Artikelnummer',
Versand.lvPicklistenposition.cString AS 'Beschreibung',
CAST(Versand.lvPicklistenposition.fAnzahl AS INT) AS 'Menge',
Versand.lvPicklistenposition.nIstStueckliste AS 'Stückliste',
Versand.lvPicklistenposition.nStatus AS 'Status',
CONVERT(varchar,tPicklistePosStatus.dZeitstempel,121) AS 'Zeitstempel',
tbenutzer.cName AS 'Benutzer',
tWarenlagerPlatz.cName AS 'Lagerplatz'
FROM Versand.lvPicklistenposition
LEFT JOIN tPicklistePosStatus ON tPicklistePosStatus.kPicklistePos = Versand.lvPicklistenposition.kPicklistePos
LEFT JOIN tbenutzer ON tbenutzer.kBenutzer = tPicklistePosStatus.kbenutzer
LEFT JOIN tPicklistePos ON tPicklistePos.kPicklistePos = Versand.lvPicklistenposition.kPicklistePos
LEFT JOIN tWarenlagerPlatz ON tWarenlagerPlatz.kWarenlagerPlatz = tPicklistePos.kWarenlagerPlatz
WHERE
Versand.lvPicklistenposition.kPickliste = @Key AND
(tPicklistePosStatus.nStatus = '20' OR tPicklistePosStatus.nStatus = '30')
ORDER BY tPicklistePosStatus.dZeitstempel ASC;