Hallo,
versuche es doch mal damit:
SQL-Code:
select
Article.ArticleNumber,
Article.EAN,
Article.Supplier,
ArticlePropertySize.Value As Size,
ArticlePropertyColor.Value As Color
from Article,
ArticleProperty ArticlePropertySize,
ArticleProperty ArticlePropertyColor
where Article.ArticleNumber = ArticlePropertySize.ArticleNumber and ArticlePropertySize.TypeID = 'Size'
and Article.ArticleNumber = ArticlePropertyColor.ArticleNumber and ArticlePropertyColor.TypeID = 'Color'
Die Tabelle ArticleProperty wird zweimal in das From genommen, um einmal den Satz mit TypeID = Size und einmal den Satz mit TypeID = Color zu lesen.