sql语句报错（急，在线等！求达人速答！谢谢！）

[candlelight]

我在mysql得前端查看工具mysql-front里面执行一下语句是正常得
SELECT * from userarchive200607 where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
group by usernumber_str having sum(userfee_mon) > 10
and UserMainRecordFlag_STR = '主记录' order by UserNumber_STR
可是为什么我在用java连接数据库后执行以上语句却报出如下错误：
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m') group b
y usernumber_str having sum(userfee_mon) > 100 and UserMainRecordFlag_STR = '主
记录' order by UserNumber_STR

java.sql.SQLException: Column not found, message from server: "Unknown column '
UserMainRecordFlag_STR' in 'having clause'"
我那个列在数据库中的确是存在的啊！

[candlelight]

怎么没人帮偶啊？！
自己先顶下

[mschen]

-- 你写的SQL语句有问题吧.好象应该这样.

SELECT * from userarchive200607
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
and UserMainRecordFlag_STR = '主记录'
group by usernumber_str
having sum(userfee_mon) > 10
order by UserNumber_STR;

[candlelight]

^_^
写成SELECT * from userarchive200607 where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
group by usernumber_str having sum(userfee_mon) > 10
and UserMainRecordFlag_STR = '主记录' order by UserNumber_STR

在sql里面也可以执行哈
但是用java就不行了
由于其他原因不能写成
SELECT * from userarchive200607
where date_format(belongingym_dte,'%Y-%m')<>date_format(now(),'%Y-%m')
and UserMainRecordFlag_STR = '主记录'
group by usernumber_str
having sum(userfee_mon) > 10
order by UserNumber_STR;

[goodgod105]

你建立sqlbean了么
是不是那错了啊 而且数据库要对应