diff --git a/api.go b/api.go
index 8afed5e..3c50f99 100644
--- a/api.go
+++ b/api.go
@@ -133,7 +133,7 @@
 			AND UPPER(a.status) = 'APPROVED'
 			AND c.id = $1 
 			AND c.tenant_id = $2)
-		UNION
+		UNION ALL
 		SELECT
 			ap.api_resources,
 			ap.environments,