Collections:
Inner Join with the WHERE Clause in MySQL
How To Write an Inner Join with the WHERE Clause in MySQL?
✍: 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:
mysql> 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 | +-----+-------------------+-----------+ 3 rows in set (0.00 sec)
⇒ Assign Names to Query Output Columns in MySQL
⇐ Query with a Full Outer Join in MySQL
2017-09-28, 1906🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...