sql多表查询用到 distinct 问题,
select mainlog.* from mainlog,sublog where mainlog.mainid=sublog.retomainid order by sublog.subid desc
发现 有重复记录,
我改用select distinct mainlog.* from mainlog,sublog where mainlog.mainid=sublog.retomainid order by sublog.subid desc
这样 查询分析器提示:
如果指定了 SELECT DISTINCT,那么 ORDER BY 子句中的项就必须出现在选择列表中。
我该怎么改呢,谢谢!