Hello,
i have a SELECT Query. Here is the Code:
SELECT a.Articlenumber, a.Description, zu.Articlenumber2
FROM Artikel a
INNER JOIN ZugeordneteArtikel zu
ON zu.Articlenumber2 = a.Articlenumber
WHERE a.Bezeichnung like '%(XXYY 2)'
This is all rights, but i need the Description from the Articlenumber2 which also in the Table Artikel. How can i show this after Articlenumber 2?
Thanks