D-Net

CREATE OR REPLACE VIEW temp_compliances AS 

	SELECT 

		a.id                 as api, 

		a.compatibilityclass as compliance

	FROM 

		api a

	WHERE

		a.id NOT IN (SELECT api from apicollections WHERE param = 'overriding_compliance')

	UNION SELECT

		a.id as api, 

		ac.original as compliance

	FROM

		api a LEFT OUTER JOIN apicollections ac ON (ac.api = a.id) 

	WHERE

		ac.param = 'overriding_compliance';