I have the following SQL query where Im getting the display value and group dimension data.
SELECT DISTINCT DAVS.RECID, DAVSI.DisplayValue, GroupDimension /*= ISNULL(GroupDimension, '') */
FROM D365.DimensionAttributeValueSet DAVS
INNER JOIN D365.DimensionAttributeValueSetItem DAVSI ON DAVS.RECID = DAVSI.DIMENSIONATTRIBUTEVALUESET AND DAVS.PARTITION = DAVSI.PARTITION
INNER JOIN D365.DimensionAttributeValue DAV ON DAVSI.DIMENSIONATTRIBUTEVALUE = DAV.RECID AND DAVSI.PARTITION = DAV.PARTITION
INNER JOIN D365.DimensionAttribute DA ON DAV.DIMENSIONATTRIBUTE = DA.RECID AND DAV.PARTITION = DA.PARTITION
WHERE [Name] = 'Producttype'
But I would like to also add one more INNER join with DimensionAttributeValueCombination table but Im having hard time to find a relationship with other tables.
How can I join?


Report
All responses (
Answers (