What Is Using Clause And Give Example?

1.	What Is Using Clause And Give Example?
Answer» The USING clause is used to SPECIFY with the COLUMN to test for EQUALITY when two TABLES are joined. [sql]SELECT * from table1 join table2 using table1 ID[/sql] table1 tables join with the table2 tables with the tableID. The USING clause is used to specify with the column to test for equality when two tables are joined. [sql]Select * from table1 join table2 using table1 ID[/sql] table1 tables join with the table2 tables with the tableID.

Answer»

The USING clause is used to SPECIFY with the COLUMN to test for EQUALITY when two TABLES are joined.

[sql]SELECT * from table1 join table2 using table1 ID[/sql]

table1 tables join with the table2 tables with the tableID.

The USING clause is used to specify with the column to test for equality when two tables are joined.

[sql]Select * from table1 join table2 using table1 ID[/sql]

table1 tables join with the table2 tables with the tableID.

Discussion