#12002/9/26 16:42:44
大家帮我看看下面的代码哪里错了,INNER JOIN的用法我还不会,我是用ACCESS的查询表生成的SQL粘贴到UD的记录集面板中的,在ACCESS中可以,但是在网页中却不行了。
SELECT gongqiu.id, gongqiu.subject, gongqiu.youxiaoqi, gongqiu.gongqiu, gongqiu.miaoshu, reguser.region
FROM reguser INNER JOIN gongqiu ON reguser.id = gongqiu.user_id
WHERE (((gongqiu.view)="Y"))
ORDER BY gongqiu.regtime desc;