SELECT * FROM
superintendent AS su
Inner Join client_info AS ci ON su.username = ci.super_user
Inner Join addmessage as addm ON ci.username = addm.username
where su.username='zhouyou' order by addm.`date` desc 这条语句查出一些结果集
我想再在这个结果集里 查询 。
查询 addmessage 表中的字段 username =‘某个值’时 的情况大家看看改怎么写?
superintendent AS su
Inner Join client_info AS ci ON su.username = ci.super_user
Inner Join addmessage as addm ON ci.username = addm.username
where su.username='zhouyou' order by addm.`date` desc 这条语句查出一些结果集
我想再在这个结果集里 查询 。
查询 addmessage 表中的字段 username =‘某个值’时 的情况大家看看改怎么写?
superintendent AS su
Inner Join client_info AS ci ON su.username = ci.super_user
Inner Join addmessage as addm ON ci.username = addm.username
where su.username='zhouyou'
and addm.username='某个值' -- ACMAIN
order by addm.`date` desc