从“哪里”删除

您可以使用

exists

DELETe  FROM table1 WHERe exists(SELECt 1  FROM table2 WHERe table2.stn = table1.stn   and table2.jaar = year(table1.datum)       )