日期:2014-05-17 浏览次数:20519 次
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
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)