Combine the two tables by running the "CREATE VIEW" command to make a new table. The first part of the MySQL statement identifies the columns from the first table, and the "INNER JOIN" command ...