All language subtitles for 2. Exercise 11 Subqueries

Hi everyone
1

Now you have learnt a very powerful tool
2

Called subquery
3

Using subquery
4

You'll have to achieve this task
5

If you remember
6

Your sales table
7

Contains only customer id as customer information and product id as product information
8

Now if you want to create a master sales table which has
9

Important customer details and product details also
10

You will need to join the sales product and customer table
11

I want you to subquery
12

And achieve this task
13

Where I want you to get all columns of sales table
14

Customer name
15

Customer age
16

Product name and product category
17

In the same result set
18

So it will have two joins one will be in the subquery and the other one will be in the outer query
19

This can also be done without using subquery
20

By using a single join statement
21

Try to do that also and compare your result if you face any difficulty
22

Do post your doubt in the discussion forum
23

Once you are done with this you will be able to use joins and subqueries very comfortably and you can move on to the next video lecture