Chapter 8, Problem 50P

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM TABLE_NAME;

INNER JOIN keyword:

“INNER JOIN” keyword is used to select all the matching records of both the tables.

Syntax:

SELECT col_Name FROM table_Name1 INNER JOIN table_Name2 ON table_Name1.col_Name = table_Name2.col_Name;