You are here
Home > 2017 > July


INNER JOIN Inner join is same as join, so we can use either inner join or join keyword. Using this join we can joins two or more tables and we can also specify more then one predicate in the ON clause. This type of join can be used in situations

SQL :Join

SQL JOIN Sometimes it is necessary to work with multiple tables using single query. Joins are used to achieve this. Tables are joined on columns that have the same data type and length in the tables. Tables in a database can be related based on primary and foreign keys. A primary