Collections:
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 GO 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
2016-10-29, 1342🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...