Code: Select all
SELECT
*
FROM
cases
INNER JOIN zzzzsys_user
ON cases.pk_inv_contact = zzzzsys_user.sus_name
WHERE ('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '12')
OR ('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '13')
OR ('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '15')
OR ('#USER_ID#' = '68df1c6014e1719' AND pk_inv_case_no = '20')
OR ('#USER_ID#' = '68e0e8f88813bf3' AND pk_inv_case_no = '21')
OR ('#USER_ID#' NOT IN ('68daccef88dbe69','68d858650166554','68d883538d9b830','68d885c9ebe0dee','68df1c6014e1719','68e0e8f88813bf3'))
OR '#GLOBAL_ACCESS#' = '1'
Code: Select all
SELECT
*
FROM
cases
INNER JOIN zzzzsys_user
ON cases.pk_inv_contact = zzzzsys_user.sus_name
WHERE (('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '12')
OR ('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '13')
OR ('#USER_ID#' = '68d858650166554' AND pk_inv_case_no = '15')
OR ('#USER_ID#' = '68df1c6014e1719' AND pk_inv_case_no = '20')
OR ('#USER_ID#' = '68e0e8f88813bf3' AND pk_inv_case_no = '21')
OR ('#USER_ID#' NOT IN ('68daccef88dbe69','68d858650166554','68d883538d9b830','68d885c9ebe0dee','68df1c6014e1719','68e0e8f88813bf3'))
OR '#GLOBAL_ACCESS#' = '1');