Using SELECT. A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the statement’s FROM clause to combine results from multiple tables.