How to join table?

Question

give the practical program.

Answer 1

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...

Answer 2

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.