Writing Inner Joins with the WHERE Clause in SQL Server


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

✍: FYIcenter.com


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
id      url                     comment
101     dev.fyicenter.com       The best
102     dba.fyicenter.com       Well done
103     sqa.fyicenter.com       Thumbs up


"AS" - Naming Query Output Columns in SQL Server

"FULL OUTER JOIN ... ON" - Writing Queries with Full Outer Joins in SQL Server

Using SELECT Statements with Joins and Subqueries in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-29, 1318🔥, 0💬