Does SQL table join order matter?

[@American5585]

so happy I could find advanced SQL channel. Keep it up!

[@RomanPeralta]

I wish I would have found this amazing channel before. You rock Bert!

[@vitor613]

That is exactly was I was searching for. Thank you!

[@sabuein]

Thank you, Bert, very much.

[@osPA78]

Great explanation on JOIN orders. Definitely learned a good amount from you video! Thank you!!!

[@ironknight132]

Thank you sir! Helpful video!

[@verokster]

Great explanation and tricks. Thank you

[@youyilin6592]

Thanks Bert!!!

[@nsrchndshkh]

Thanks Man for the explanation

[@kirankumarkommalapudi9947]

Thanks for sharing.

[@BeRNisira]

thanks for your videos!

[@purnachandrak2148]

Nice vedio bert, can you make a vedio on execution plans.

[@NoFeetOnEarth]

Great vid indeed! Would you be able to answer a question i've asked myself for a while, but no expert I could ask to?
I've read an index can only used once for a query, does that mean for only 1 join, even if multiple different joins could use this index?

[@NoFeetOnEarth]

@@DataWithBert Hi Bert, thanks for the reply, this is actually never happening :D
You're right, my question was not clear.
What I am referring to is the following statement "SQL Server can use only one index for each table that is present in the query".
What does that mean exactly?
Also, if the table is present in a join and also in the WHERE clause, is it considered the same "join" or the WHERE clause is separated from the other joins that use the tables?
Thanks in advance

[@sharathsreedhar3153]

Good video. Please lose the background Music(noise).

[@marcosoliveira8731]

That´s it.
+1