CREATE TABLE Organizations (organization_details VARCHAR2, organization_id VARCHAR2)
CREATE TABLE Things (thing_id VARCHAR2, type_of_Thing_Code VARCHAR2, organization_id VARCHAR2)

List the id and type of each thing, and the details of the organization that owns it.
SELECT T1.thing_id, T1.type_of_Thing_Code, T2.organization_details FROM Things AS T1 JOIN Organizations AS T2 ON T1.organization_id = T2.organization_id
SELECT "T1"."thing_id", "T1"."type_of_Thing_Code", "T2"."organization_details" FROM "Things" "T1" JOIN "Organizations" "T2" ON "T1"."organization_id" = "T2"."organization_id"