You are here
Home > Posts tagged "equi join"

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

Top