mySQL 从两个表中选择并匹配结果

Question

我愿意

SELECT DISTINCT column1, column2 as t1

我愿意

SELECT column3 FROM table2 WHERE column4 = "1" AND column3 = (matches)t1.column1

我的查询应该是什么样子？

SELECT DISTINCT column1, column2 FROM table1 as t1,
column3 FROM table2 WHERE column4 = "1" AND column3 = t1.column1

结果应该是一个包含第 1 列数据的列表，与第 3 列和第 4 列 = 1 的数据相匹配

Table1:                Table2:
-----------------------------------------
column1    column2     column3    column4
-----------------------------------------
001        Name        001        1      
002        Name        002        0
003        Name        004        1
005        Name        005        1
-----------------------------------------
Result: 001, 005     

错误:

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM table2 WHERE column4 = '1' AND column3 = t1.column1' at line 1

Answer 1

select distinct
   t1.column1,
   t1.column2,
   t2.column4
from
   table1 as t1
inner join
   table2 as t2 on t2.column3 = t1.column1
where
   column4 = "1"