Thought this might help, if you aren’t coming from an SQL background then it will probably confuse!
Two Tables, not linked (we can do that another day). Let’s not think about duplicate values either.
Parrot, Banana, Monkey, Apple
Ruby, Banana, Diamond, Apple
SELECT * FROM TableA
INNER JOIN TableB
ON TableA.name = TableB.name
In Bubble this is achieved via an INTERSECT of two searches.