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, 1437🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...