Populate Drop Down List using AND DB query

I am very new to bubble.io.

I have a db table of products that have users email addresses associated with them
I am trying to populate a dropdown list from the database with an AND query based on email addresses. Both email address are in the same table.

The query I’d like to use would be:
email address = ‘logged in users email address’ AND email address = ‘zzz@domain.com’

SQL would look similar to
SELECT * From table_name where emailaddress = loggedinusersemailaddress AND emailaddress = ‘zzz@domain.com’

Maybe you want the :merged with operator. So [search 1]:merged with [Search 2] then you’ll need to add :sorted after if you want it alphabetical or something.

Thank you that worked.

1 Like