Hi,

After a few years of not using SQL, I have some problems to find the right query. There are 4 tables:
Substance: ID, Name
SubstanceProperty: ID, SubstanceID, Value, PropertyPropertyGroupID
PropertyPropertyGroup: ID, PropertyID
Property: ID, Code

In each table 'ID' is the primary key. SubstanceID links to Substance.ID, PropertyPropertyGroupID to PropertyPropertyGroup.ID and PropertyPropertyGroupID.PropertyID to Property.ID. Now I want to select the Code of the Property, the Value of the PropertyPropertyGroup and the Name of a Substance for a specific Substance.ID.

How can I handle this?

thx,
Pieter