表1 项目
ID 序号
名称
...
--------------------------
表2 跟进
项目ID
跟进时间
跟进内容做一个列表页面,要显示按跟进时间排序的项目并统计跟进次数。
我写的sql语句是
select A.* from product as A right join (select * from genjin where finder like '"&session("xingming")&"') as B on A.p_id = B.p_id where p_name<>'' order by B.g_time desc
但是这句显示结果是按照最新跟进时间排序并且能统计跟进次数的列表,可是却根据跟进的次数重复显示多次项目标题。
求 只显示最后一次跟进时间的项目,谢谢
ID 序号
名称
...
--------------------------
表2 跟进
项目ID
跟进时间
跟进内容做一个列表页面,要显示按跟进时间排序的项目并统计跟进次数。
我写的sql语句是
select A.* from product as A right join (select * from genjin where finder like '"&session("xingming")&"') as B on A.p_id = B.p_id where p_name<>'' order by B.g_time desc
但是这句显示结果是按照最新跟进时间排序并且能统计跟进次数的列表,可是却根据跟进的次数重复显示多次项目标题。
求 只显示最后一次跟进时间的项目,谢谢
from product as A
right join genjin as B on A.p_id = B.p_id
--where B.finder like '"&session("xingming")&"'
group by A.p_id不知能不能帮到你?
order by B.g_time desc拜托了
select A.id,a.xuhao,a.name,max(b.genjinshijian),count(1) from product as A inner join
genjin b on a.id=b.id group by a.id
order by max(b.genjinshijian)
select A.id,a.xuhao,a.name,max(b.genjinshijian),count(1) from product as A inner join
genjin b on a.id=b.id group by a.id,a.xuhao,a.name
order by max(b.genjinshijian)