22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT A.CONTENT, B,USERNAME
FROM
(
SELECT CONTENT , USERCODE, SUBMITTIME FROM 表 WHERE USERCODE = '' AND SUBMITTIME BETWEEN ‘时间1' AND '时间2'
) A , USERINFO B
WHERE A.USERCODE = B.USERCODE
SELECT A.CONTENT, B,USERNAME from 表 a inner join userinfo b on a.usercode=b.cusecode
where a.usercode='' and a.SUBMITTIME BETWEEN '时间1' AND '时间2'
SELECT A.CONTENT, B,USERNAME from 表 a inner join userinfo b on a.usercode=b.cusecode
where usercode='' and SUBMITTIME BETWEEN '时间1' AND '时间2'