Show the property type descriptions of properties belonging to that code.
create table properties (property_type_code varchar, PRIMARY KEY (property_type_code)); create table ref_property_types (property_type_description varchar, property_type_code varchar, PRIMARY KEY (property_type_description))
select t2.property_type_description from properties as t1 join ref_property_types as t2 on t1.property_type_code = t2.property_type_code group by t1.property_type_code