In How many ways we can use Inner join ?
as well as Left Join ?
In a LEFT join, all the records from the first table are kept, and only those records from the second table that match a record in the first table are kept.
In an INNER join, only records with a match across both tables will be kept.
we can join tables with table names, is it possible to join with cloumn names?
yes it is possible to join with column name i mean you just have Key column in both tables on which you make your join.
C from ABC1.xls
D from ABC2.xls
Inner Join take all data where data matches in both table and left join take all data from left table
Retrieving data ...