Original subtitles

0 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