32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join | Interview Topic

[@fjeewani]

thank you.... you are a savior.... God bless you.

[@mmohan692]

U r a life saver

[@pavankumark5611]

Hi Saloni, Can you make a video on how to create Stored Procedure as-well in this playlist! loved your content very good job 👍

[@trustingod0]

Is there a method you use to break a problem down into parts before writing the query. Thank You !!!

[@ajsunofficial6798]

I need to get a sum of amount from each monthly table of transactions which are connected to a master table ....12 monthly tables vs master table

[@AmitDhaygude-p1p]

where is 31st video of this playlist? not able to find it

[@CodeEra2020]

kzbin.info/www/bejne/rWq7aneLrc-nkM0 Here the link of 31st video or you can also check in the playlist Thank you for watching

[@mmohan692]

Bcz of ur all video only I placed in Microsoft

[@trustingod0]

How do I contact you. You are an excellent teacher

[@rishabhchouksey3288]

Heyy, Can you please share the solution of the question you asked

[@CodeEra2020]

SELECT p.prod_id, c.cust_name, c.cust_city, o.order_date, p.prod_price FROM customers c INNER JOIN orders o ON c.cust_id = o.cust_id INNER JOIN product_details p ON o.order_id = p.order_id WHERE c.cust_name = 'David';

[@kiransonone702]

@@CodeEra2020 I tried to solve it by my own and my answer was correct .... Thanks for teaching in very detail

[@CodeEra2020]

@@kiransonone702 Great..😊 keep learning ❤

[@nolantrevannion6160]

'Promosm'

[@passportbro904]

im from the uk, can i come and marry you

[@JenniferRistau]

I think the answer to the question would be something like this SELECT product_id, customer_name, cust_cit, order_date, product_price FROM (SELECT * FROM customers WHERE customer_name = 'David') INNER JOIN orders o ON c.cust_id = o.cust_id INNER JOIN product_details pd ON o.order_id = pd.order_id OR SELECT product_id, customer_name, cust_cit, order_date, product_price FROM customers INNER JOIN orders o ON c.cust_id = o.cust_id INNER JOIN product_details pd ON o.order_id = pd.order_id WHERE customer_name = 'David'

[@jaishreepushparaman7307]

Is this correct

[@aqilhms]

SELECT p.prod_id,c.cust_name,c.cust_city,o.order_date, p.prod_price FROM customers c INNER JOIN orders o ON c.cust_id = o.cust_id INNER JOIN products_details p On p.order_id = o.order_id where c.cust_name = 'David'; PR01 David Munice 2020-01-12 3.49