29-04-2014, 12:12 PM
SQL COMMANDS FOR NESTED QUERIES AND JOIN QUERIES
AIM
To execute and verify the SQL commands using nested queries and Join queries.
PROCEDURE
STEP 1: Start
STEP 2: Create the table with its essential attributes.
STEP 3: Insert attribute values into the table
STEP 4: Execute different Commands and extract information from the table.
STEP 5: Stop
SQL COMMANDS
1. COMMAND NAME: INNER JOIN
COMMAND DESCRIPTION: INNER JOIN command returns the matching rows from the
tables that are being joined.
2. COMMAND NAME: LEFT OUTER JOIN
COMMAND DESCRIPTION: LEFT OUTER JOIN command returns matching rows from
the tables being joined and also non-matching row from the left table in the result and places
null values in the attributes that come from the right side table.
3. COMMAND NAME: RIGHT OUTER JOIN
COMMAND DESCRIPTION: RIGHT OUTER JOIN command returns matching rows from
the tables being joined and also non-matching row from the right table in the result and places
null values in the attributes that come from the left side table.
4. COMMAND NAME: NESTED QUERY
COMMAND DESCRIPTION: NESTED QUERY command have query within another query.