You are here
Home > Posts tagged "sql joins"

SQL JOIN (INNER JOIN)

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 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

Top