Hi guys,
These days I work with SQL Execution plans, when I have to detailed analysis of exactly my query execution, I realize don't have a difference between the two ways to get data from two tables on the match field.
In this post, I mention INNER JOIN
#type 1
SELECT
u.UserName
,w.Name
FROM dbo.Users u, dbo.Wallets w
WHERE u.UserGuid = w.UserGuid
with
#type 2
SELECT
u.UserName
,w.Name
FROM dbo.Users u
JOIN Wallets w on u.UserGuid = w.UserGuid
If I execute the query above with the execution plan then I have the plan below:
#type 1
#type 2
Just example for this post 😁😁
Top comments (0)