diff --git a/api.go b/api.go
index dbddea5..216d1bd 100644
--- a/api.go
+++ b/api.go
@@ -131,7 +131,7 @@
 			AND UPPER(a.status) = 'APPROVED'
 			AND c.id = $1 
 			AND c.tenant_id = $2)
-		UNION
+		UNION ALL
 		SELECT
 			ap.api_resources,
 			ap.environments,