Select field1 from table1 where exists (select fields1from table2);
The above SQL generates error: "#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS( SELECT field1 FROM table2 ) LIMIT 0, 30' at line 3
But the sql is an example in MySQL manual and it passed the test on MS ACCESS. I also tried to change 'exists' to
'field1 in' or 'field1 = any' or 'fields is ', none of them works.