How Union better(WHERE or JOIN)?

Scheme:
fac60f1505fe46bf999b22c12e4b88bd.PNG

Association with a JOIN:
5b729292d071406fa5840006a6b3746e.PNG
Code:
SELECT Wizards.Name AS the Master Services.Name AS Name, 
Services.The cost AS Cost, Services.Polovians AS [Gender]
FROM Services 
INNER JOIN (Wizards 
 INNER JOIN Masterplug 
 ON the Masters.Codemaster=Masterplug.Codemaster) 
ON Services.Codului=Masterplug.Codului;


Join using WHERE clause:
dfe7dcaef71941f0a27dd26f83c3e15b.PNG
Code:
SELECT Wizards.Name AS the Master Services.Name AS Name, 
Services.The cost AS Cost, Services.Polovians AS [Gender]
FROM the Masters, Services, Masterplug
WHERE Wizards.Codemaster = Masterplug.Codemaster 
AND Services.Codului = Masterplug.Codului;


They output the same thing. Which query is better to use for such purposes?
July 9th 19 at 10:19
2 answers
July 9th 19 at 10:21
Solution
So many tags of different databases, each database has its own profiling tools, run both queries through them. If both queries run equally fast, then the best option that is more friendly and pleasant.
Correctly observed. For example, in maykrosoftovskie since ancient times, the join was Bystrice than anything else. And in the old oracle syntax in the condition wvere to use analogues of join.

Additionally, the speed can raise a competent use of the indexes. - scottie.Walk commented on July 9th 19 at 10:24
July 9th 19 at 10:23
The first option is not very good, that contains a subquery, and this additional execution time.
The version with commas is quite right to existence, but, in my opinion, is not very convenient to read.

I would write something like this
SELECT Wizards.Name AS the Master Services.Name AS Name, Services.The cost AS Cost, Services.Polovians AS [Gender]
FROM Masterplug
INNER JOIN Wizards
ON the Masters.Codemaster = Masterplug.Codemaster 
INNER JOIN Services
ON Services.Codului = Masterplug.Codului
I may surprise you, but sometimes subqueries work faster joynow. Therefore, only the profiling. - scottie.Walk commented on July 9th 19 at 10:26
In General, I agree, especially since the tags in different databases, it is necessary to look. In particular, the 3 dB mostly worked with ms sql and subqueries are usually caused brakes. - aniya.Kertzmann65 commented on July 9th 19 at 10:29
Everything depends on the particular optimizer queries, and a set of data. And not the fact that after the change of the structure of the tables will still work well. - brendon78 commented on July 9th 19 at 10:32

Find more questions by tags Microsoft AccessSQL ServerMySQLSQL