SQL INNER JOIN

INNER JOIN keyword returns rows when there is at least one match in both tables.

SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name;

Online Execute/Compile
SELECT fname FROM persons INNER JOIN orders ON persons.u_key=orders.u_key;