database technologies lab
software to use putty
create 4 tables, each table should be interlink.
( don’t consider for example – bank = account )
Lab Homework 4B requires you to implement all the 7 type of joins discussed in the lab. Each join should have at least 2 queries
1) Inner Join
2) Left Outer join
3) Right outer join
4) Natural join
5) Equi Join
6) Cross join
7) Self Join
Write SQL query, SQL output, SQL output description for each command.