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, 1426🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...