Multi Table Queries

Communicator
Tools
Profile Settings

Loading, please wait ...

Open its course - Database Systems Labs

Multi Table Queries By Mukhtiar Zamin
Summary

Summary

4
Teachers with
Mukhtiar Zamin 19
Followers
For Learning All
Visibility
Security Status 2
Contributions
By Teachers

Notes

Students are auto-evaluated against related topics to ensure they learned it.

Students will learn how access data from multiple tables using different types of joins

Scope

Displaying data from multiple tables.
Joins
Inner join
Left outer join
Right outer join

Introduction

To combine columns from several tables into a result table we need to use a join operation. The SQL join operation combines information from two tables by forming pairs of related rows from the two tables. The row pairs that make up the joined table are those where the matching columns in each of the two tables have the same value.

If we need to access data from more than one table, the choice is between using a subquery and using a join. If the final result table is to contain columns from different tables, then we must use a join.

Lab Tasks for All, By Mukhtiar Zamin

Select customers name, number , phone from customers table, select checknumber from payments table. Display it for all customers. [either they have made payment or they haven’t include all customers].
Display orderdetails for products. Use inner join.
Using right outer join for productline display products.
Select customers name and order he made for id =103. Use AND with inner join.

Video on Lab for All, By Mukhtiar Zamin