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

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!

📚 SQL Practice Questions -

🔶Create Employee Table

🔶Insert Data into Employee Table

Connect with us on different platforms

📌31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN

📌30-Introduction to Joins & its types | Need of Joins with example

📌29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus

📌28-Conversion Functions in SQL| CAST VS CONVERT | STR_TO_DATE

📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...

📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()

📌25-String Functions in SQL

📌24-Difference Between WHERE and HAVING CLAUSE in SQL

📌23-HAVING CLAUSE in SQL

📌22 -GROUP BY Clause in SQL

📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN

📌20 -TOP Clause in SQL | FETCH FIRST Clause

📌19- LIMIT and OFFSET in SQL

📌18- ORDER BY Clause in SQL

⭐Part 1:Top 9 SQL queries for interview -

⭐Part 2:Top 9 SQL queries for interview -

⭐Top SQL Interview Question

⭐Interview SQL Query On Joins

⭐DBMS vs RDBMS

⭐SQL Query To Swap Value Of Male and Female In Single Statement

#sql
#sqlcourse
#join
#sqlforbeginners
#innerjoin
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#sql
#having
#sqlhavingclause
#groupbyclause
#sqlgroupbyclause
#sqlselectcommand
#LearnCoding
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncodin
#clause
#sqlserver
#top
#sqlqueries
#join
#innerjoin

[fjeewani]

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

[pavankumark]

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

[girish]

Why the employee table is main table?? (03:55)

[trustingod]

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

[ganeshk]

for me Product, Customer, product_details tables does not seems right modelling . Oder table should have product_id And product_details shouldn't have order_id . This is what I think please think over.

[mmohan]

Bcz of ur all video only I placed in Microsoft

[rafikundurthi]

why are we getting only one cust_id in output, even thought we are doing inner join
note - we know natural join don't repeat.

[ajsunofficial]

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-pp]

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

[trustingod]

How do I contact you. You are an excellent teacher

[rishabhchouksey]

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

[passportbro]

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'

[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