Code: Select all
SELECT *
FROM customer c
WHERE (c.firstname, c.lastname) IN ( ('John', 'Doe'), ('Jane', 'Doe') )
Thank you for your help.
Code: Select all
SELECT *
FROM customer c
WHERE (c.firstname, c.lastname) IN ( ('John', 'Doe'), ('Jane', 'Doe') )