SQL Multiple JOINS with MULTIPLE WHERE Condition

SQL Multiple JOINS with MULTIPLE WHERE Condition

In this video, I will teach you how can you write a query to extract data with multiple joins with multiple where condition in sql. Yes, it is a difficult query to write but a make it so simple with simple method and guidance
Here we will use Multiple INNER joins with WHERE condition include AND operator with GETDATA formula with the help of all we make a whole query to get the desired output.

#sql #joins #teachtoeach

00:15 - Understand the Question
00:01 - All Table Data
02:30 - 1st INNER Join
03:53 - 2nd INNER Join
05:18 - 1st WHERE Condition
06:06 - 2nd WHERE Condition
06:55 - 3rd WHERE Condition
07:51 - 4th WHERE Condition
08:28 – GETDATE Formula
09:49 – Run Full Query
11:48 - Add More Columns in query

Please watch this video only few videos are available on this topic of How to write a query with Multiple joins and where condition in sql in Hindi.

Most Popular Videos are :-

TAGS : SQL Multiple JOINS with MULTIPLE WHERE Condition,sql inner join,inner join,multiple inner join,multiple join in sql,sqL join with where condition,sql where condition,sql where condition with and operator,sql and operator,sql getdata formula,what is sql,sql in hindi,sql tutorial in hindi,teach to each,teach to each power bi,teach to each sql,teach to each excel,excel logical operator

[nanadriv]

Saya tidak mengerti bahasanya tapi menikmati pelajaran anda, terimakasih, anda luar biasa

[RAJAT]

NAILED IT!! THANK YOU for putting this great example together!!

[mamathadyava]

Clear explanation, Thanks for the video

[MMMEHTA]

Very NIce Skill to Teaching And Explain, I have solve my problem from your video, Very Very Thankful sir

[Capture_]

Loved the way of explaination brother... thank u so much..please come with full video for joins if possible..once again thank you

[udaychaudhari]

A very good explanatory videos, i found on this channel

[Islamm]

WELDON SIR. Very easy method for teaching. I thank you a lot sir.

[ks]

Trick to tech with good examples thanks

[nakibrahaman]

It would be very better if you also provide the Database bak file or query in the description. So, it will help us to practise directly but now we have to make table and insert data first and then practise.

[shoryaarora]

Request you to please attach practice files in each video going forward. Thank you

[RidharvJoshi]

Sir request to please make one complete video for all the joins
Right join, left join, self join, and full join

[keshulohar]

hi, same header in different tables but data change. hota to show data in mysql.
eg. A table & B table ( a.name & b.name) Name.

[srs]

Can you please attach the database link for download. So that it will help for practice

[girlfrommountains]

How can we select all these ...if we have one column giving output zero (for eg we r finding count of items with but we want to get output in every coloumn and output for this count will be displaying zero .... Wts the query for that .. (bcz i am getting empty table ..but need zero written in place of count) ... Help pls if u can

[hasanmougharbel]

Hey there, keep up the great work in your channel.
I have only a general enquiry as a newbie sql learner.
Could i channel shopify live data into an sql application? (This should be an application developed for a company of 50 employees mainly for the sake of generating reports and analytics))
Is this an easy process to undertake as a sql beginner? What should i keep in mind
and what are the tools or softwares that i should work with right from the beginning.
For notice, I made my mind to work with microsoft sql server, also our company has a dedicated server.
Thanks for taking care of my enquiry

[Odia_traders]

Sir it would helpful if you provide data

[Ravij-jkex]

try to give table creation syntax / data in woed or notepad so its easy for viewer to ptactice

[lalithroy]

Hi Bro where can I get script to create table. It will be helpful if you provide script in the description.