SELECT pt.label, pt.comment, pt.producer, productFeature, propertyTex1, propertyTex2, propertyTex3, propertyNum1, propertyNum2, propertyTex4, propertyTex5, propertyNum4 FROM product pt, producer pr, productfeatureproduct pfp WHERE pt.nr=@ProductXYZ@ AND pt.nr=pfp.product AND pt.producer=pr.nr