0

How to join table?

give the practical program.

9th Aug 2016, 5:04 AM
bhautik
2 Réponses
+ 3
Select * FROM table1 INNER JOIN table2 ON TABLE1.ID = TABLE2.ID or Select * FROM table1, table2 Where table1.id=table2.id Or Select * FROM table1 as t1, table2 as t2 Where t1.id=t2.id Note when you don't specify the type of Join, it will by default do the INNER JOIN.. Hope it will help you...
9th Aug 2016, 6:02 AM
Hardik Thaker
Hardik Thaker - avatar
0
You can join table using different join operations mentioned below. (Outer is optional) 1. Inner Join: qualifies only matching rows from both tables 2. Left Outer Join: qualifies left table and its matching right table, unmatched values will be null. 3. Right Outer Join: similar to left outer join but does the opposite.
17th Jul 2017, 4:16 PM
Mahesh Kotekar
Mahesh Kotekar - avatar