[Solution] Self Joinwrite Sql Query

[Solution] Self Joinwrite Sql Query

database technologies lab

software to use putty/sql workbench 

create any 4 tables, 

each table should be interlinked for Joinig all queries 

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.  

required:-  output of each queries of tables And join queries

 Output should be in word document. 

thank you. 

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code SAVE15 for 15% discount