Chapter 3, Problem 3.40RQ

Program Plan Intro

SQL:

• SQL stands for “Structured Query Language”.
• The current version of SQL is “ANSI SQL – 92”.
• It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.
• 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.

Table Creation:

Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

Column1 datatype,

Column2 datatype,

…

);

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.