mysql怎么实现两表连接吗,MySQL使用一个条件从两个表连接

I can't figure out join..

need to select all rows from one table where a column equals something in another table..

like this:

SELECT ALL FROM someTable

WHERE COLUMN someColumn = '123' (IN A DIFFERENT TABLE)

something like that..

and the IDs need to match of course..

解决方案

Just use an INNER JOIN:

SELECT *

FROM SomeTable S

JOIN SomeOtherTable S2

ON S.SomeKey = S2.SomeKey

WHERE S.SomeColumn = '123'

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