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

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

Рет қаралды 15,718

Жыл бұрын

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!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
📚 SQL Practice Questions -
codeera.netlify.app/sql-pract...
🔶Create Employee Table
codeera.netlify.app/wp-conten...
🔶Insert Data into Employee Table
codeera.netlify.app/wp-conten...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlify.app/
✅ Subscribe us on KZfaq: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroupCodeEra
📌31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN
• 31-INNER JOIN & NATURA...
📌30-Introduction to Joins & its types | Need of Joins with example
• 30-Introduction to Joi...
📌29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus
• 29-SET Operators in SQ...
📌28-Conversion Functions in SQL| CAST VS CONVERT | STR_TO_DATE
• 28-Conversion Function...
📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...
• 27-Date & Time Functio...
📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()
• 26-Numeric Functions i...
📌25-String Functions in SQL
• 25-String Functions in...
📌24-Difference Between WHERE and HAVING CLAUSE in SQL
• 24-Difference Between ...
📌23-HAVING CLAUSE in SQL
• 23-HAVING CLAUSE in SQ...
📌22 -GROUP BY Clause in SQL
• 22 -GROUP BY Clause in...
📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN
• 21-Aggregate Functions...
📌20 -TOP Clause in SQL | FETCH FIRST Clause
• 20 -TOP Clause in SQL ...
📌19- LIMIT and OFFSET in SQL
• 19- LIMIT and OFFSET i...
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
#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

Пікірлер: 18

@fjeewani 5 ай бұрын

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

@pavankumark5611 7 ай бұрын

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

@mmohan692 9 ай бұрын

U r a life saver

@trustingod0 7 ай бұрын

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

@ajsunofficial6798 4 ай бұрын

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

@trustingod0 7 ай бұрын

How do I contact you. You are an excellent teacher

@mmohan692 9 ай бұрын

Bcz of ur all video only I placed in Microsoft

@user-if5zu8eo2m Жыл бұрын

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

@CodeEra2020 Жыл бұрын

kzfaq.info/get/bejne/rZ-IbKeG3dDYip8.html Here the link of 31st video or you can also check in the playlist Thank you for watching

@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 11 ай бұрын

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

@CodeEra2020 11 ай бұрын

@@kiransonone702 Great..😊 keep learning ❤

@nolantrevannion6160 Жыл бұрын

'Promosm'

@passportbro904 7 күн бұрын

im from the uk, can i come and marry you

@JenniferRistau 3 ай бұрын

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 2 ай бұрын

Is this correct