IN Clause in MySQL

Anon

Dear All,
I wrote a query in MySQL to collect data from two different tables like:
select physician_info_physician_name from CTMedia_physician_info
where physician_info_physician_id
in(select call_log_physician_id from CTMedia_call_log);
It is giving an error that 'syntax error is there at line1'. The fields entered by me are correct and the two tables are related with keys. This error is teasing me for long time. So please tell me whether MySQL supports "IN CLAUSE"? If it doesn't supports what is the alternative for my problem? Please help me.

[deleted]

MySQL does support the IN clause, but MySQL does not support subqueries;

GOOD:
SELECT foo FROM bar WHERE field IN (1,2,3);

BAD:
SELECT foo FROM bar WHERE field IN (SELECT field FROM otherbar);

A forum, a FAQ, email notification, what else do you need?