简单select语句请大家帮忙看看有什么错误？谢谢

[anirvana]

select * from tb1 where m=? and g=? and c=? and id in(select id form tb2 where t=2)

[anirvana]

up

[viptiger]

select * from tb1 where m=1 and g=1 and c=1 and id in(select [id] from tb2 where t=2)

[WangZWang]

form改为from

[anirvana]

还是有错误呀：java.sql.SQLException: Syntax error or access violation, message from server: "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 'select [id] from tb2 where t=2)' at l

[zhangzs8896]

把你的这个sql语句先拷贝到查询分析器，看是什么错！
select * from tb1 where m=1 and g=1 and c=1 and id in(select [id] from tb2 where t=2)

[yown]

select * from tb1 where m=? and g=? and c=? and id in(select id form tb2 where t=2)

拼写出错:form改为from

[pressman]

把你的这个sql语句先拷贝到查询分析器，帖出完整的错误信息来！
select * from tb1 where m=1 and g=1 and c=1 and id in(select [id] from tb2 where t=2)

或者给出TB1 TB2 的表结构

[anirvana]

我用的时MySql，他显示的错误信息跟上面一样。

[anirvana]

form已经改成from了

[淡蓝冰]

1﹑form改為from
2﹑?改為%
3﹑不知"="要不要改為"=="

[anirvana]

都不行呀