select SITE_COMMON.SITE_CODE from
SITE_COMMON join COUNT_DAILY on SITE_COMMON.SITE_CODE=COUNT_DAILY.SITE_CODE
where COUNT_DAILY.COUNT_DATE>='20090717'
group by SITE_COMMON.SITE_CODE很笨的左连接问题怎么能在查询条件时间超出的时候,仍然能查出SITE_CODE的不重复数据
SITE_COMMON join COUNT_DAILY on SITE_COMMON.SITE_CODE=COUNT_DAILY.SITE_CODE
where COUNT_DAILY.COUNT_DATE>='20090717'
group by SITE_COMMON.SITE_CODE很笨的左连接问题怎么能在查询条件时间超出的时候,仍然能查出SITE_CODE的不重复数据
select SITE_COMMON.SITE_CODE from
SITE_COMMON left join COUNT_DAILY on SITE_COMMON.SITE_CODE=COUNT_DAILY.SITE_CODE
and COUNT_DAILY.COUNT_DATE>='20090717'
group by SITE_COMMON.SITE_CODE
SITE_COMMON.SITE_CODE
from
SITE_COMMON
LEFT join
COUNT_DAILY
on SITE_COMMON.SITE_CODE=COUNT_DAILY.SITE_CODE where COUNT_DAILY.COUNT_DATE>='20090717' group by SITE_COMMON.SITE_CODE ??