Chapter 3, Problem 3.38RQ

Program Plan Intro

SQL:

• SQL stands for “Structured Query Language”.
• The current version of SQL is “ANSI SQL – 92”.
• SQL is not a programming language. It is text-based and it is also called as data sublanguage.
  • In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
• It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
• Some of the DBMS products provide GUI tools in order to perform tasks are as follows:
  •  SQL Server
  • Oracle Database
  • MySQL

Display values from table:

The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML). Syntax to view the contents using asterisk (*) is as follows:

SELECT * FROM table_Name;

Columns can also be retrieved by replacing all the column names in place of the asterisk symbol.

JOIN ON Syntax:

The “JOIN ON” syntax is usually used to join two or more than two tables. This syntax usually works with “WHERE” clause. The keyword “JOIN” is normally placed between the table names in the SQL FROM clause. The keyword “ON” includes the matching key values.