You are here
Home > Posts tagged "join"


SQL JOIN Outer Join: Outer join returns all rows from one table and matching rows from second table. There are three types of Outer join: 1) Left Outer Join 2) Right Outer Join 3) Full Outer Join Syntax: select column_name(s) from table_name1 left | right | full [outer] join table_name2 on table_name1. column_name= table_name2. column_name Left Outer


SQL JOIN Inner Join or Equi Join: Inner join selects data that have matching values in tables. Inner join is same as join, so we can use either inner join or join keyword. Syntax: select column_name(s) from table_name1 inner join table_name2 on  table_name1.column_name=  table_name2.column_name   OR   select column_name(s) from table_name1 join table_name2 on  table_name1.column_name=  table_name2.column_name Database Table: Customers Cust_id Name Age City 1 Prince 22 Anand 2 Komal 44 Pune 3 Khusi 30 Delhi 4 Anil 45 Mumbai 5 Abhi 27 Ahmedabad 6 Juhi 35 Baroda Here, Cust_id


SQL JOIN Sql join is used to combine data from two or more tables in a database. Join keyword is used to join one (self-table) or more tables in sql query. According to ANSI SQL-89 syntax for joining two tables: select [column-list] from table_name1,table_name2 where <where predicate> According to ANSI SQL-92 syntax