33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN | Types of JOINS | Examples| Interview Topic

[@SHREERANGWARHADPANDE]

Haven't uploaded the joins & sub queries questions yet? Please do when you get a chance.

[@sandyiwadeakhia4435]

Pls, how do you create three tables using the foreign key?

[@ranaprathap8292]

Practice questions not available in our website

[@ranaprathap8292]

How to find which join are used?

[@debtamrakar5821]

How to know which Join need to use?

[@PriyaGupta-qj1zb]

why there is no practice question of left and right join

[@debtamrakar5821]

Do you have Left Join with multiple tables?

[@bluesparrow2.027]

Hi saloni me interview me join ki query me bar bar fail ho rha ab mujhe smjh nhi aa rha h kya kru

[@ranaprathap8292]

How to find the join ?

[@CodeEra2020]

Please elaborat your question.

[@ranaprathap8292]

How to find which join are used that question?

[@jedits7835]

right join is confusing

[@adityarajbhandare5166]

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