Writing Inner Joins with the WHERE Clause in SQL Server

Q

How To Write an Inner Join with the WHERE Clause in SQL Server?

✍: FYIcenter.com

A

If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example:

SELECT l.id, l.url, r.comment 
   FROM fyi_links l, fyi_rates r WHERE l.id = r.id
GO
id      url                     comment
101     dev.fyicenter.com       The best
102     dba.fyicenter.com       Well done
103     sqa.fyicenter.com       Thumbs up

 

Using SELECT Statements with Joins and Subqueries in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-29, 670👍, 0💬