MySQL从两个具有一个条件的表联接 [英] MySQL join from two tables with one condition

问题描述

我不知道要加入..
需要从一个表中选择所有行，其中一列等于另一个表中的某项.

I can't figure out join..
need to select all rows from one table where a column equals something in another table..

像这样:

SELECT ALL FROM someTable 
WHERE COLUMN someColumn = '123' (IN A DIFFERENT TABLE) 

类似的东西.. 而且ID当然要匹配.

something like that.. and the IDs need to match of course..

推荐答案

只需使用INNER JOIN:

SELECT * 
FROM SomeTable S
    JOIN SomeOtherTable S2 
        ON S.SomeKey = S2.SomeKey
WHERE S.SomeColumn = '123'

• SQL连接的直观说明
• A Visual Explanation of SQL Joins

我对您的问题并不完全清楚，因此，如果该子句代表了您的JOIN标准，则可能不需要WHERE子句.

I wasn't completely clear of your question, so you may not need the WHERE clause if that represented your JOIN criteria.

这篇关于MySQL从两个具有一个条件的表联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！