How to join table? | Sololearn: Learn to code for FREE!

How to join table?

give the practical program.

9th Aug 2016, 5:04 AM
2 ответов
+ 3
Select * FROM table1 INNER JOIN table2 ON TABLE1.ID = TABLE2.ID or Select * FROM table1, table2 Where Or Select * FROM table1 as t1, table2 as t2 Where 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
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