I have a query I'm trying to run that has a UNION ALL but I need different limits on each SELECT. See below:
(SELECT
"Users"."User ID" as "User ID",
"Users"."Employee ID" as "Employee ID",
"Users"."Role" as "Role",
"Users"."First Name" as "First Name",
"Users"."Last Name" as "Last Name",
"UserProduct"."Product ID" as "Product ID"
FROM "Users",
"UserProduct"
WHERE ("Users"."User ID" = "UserProduct"."User ID"
AND "Users"."Role" = 'Child') LIMIT 1 OFFSET 2)
UNION ALL
(SELECT
"Users"."User ID" as "User ID",
"Users"."Employee ID" as "Employee ID",
' ' as "Role",
' ' as "First Name",
' ' as "Last Name",
"UserProduct"."Product ID" as "Product ID"
FROM "Users",
"UserProduct"
WHERE ("Users"."User ID" = "UserProduct"."User ID"
AND "Users"."Role" = 'Primary')
LIMIT 1)