SELECT
‘2015-02-28’ as startdate,
(
SELECT
DATEADD(DAY, 2, '2015-02-28')
FROM
t_agreement_project ap
WHERE
ap.id = 14
) as addDayDate
FROM
t_agreement a
LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id
GROUP BY startdate,addDayDate
GROUP BY出错，请问大家这种情况应该怎么改?
我就是想去掉重复的数据。谢谢大家...
------解决思路----------------------
-- 是这个意思吗？
SELECT '2015-02-28' as startdate,DATEADD(DAY, 2, '2015-02-28') as addDayDate
FROM t_agreement a
LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id
------解决思路----------------------
这两列数据，都从哪里来？ 你的好像都是常量来的。。。
你可以替换成你的字段，
-- 大概如下
SELECT distinct '2015-02-28' as startdate,DATEADD(colname, 2, '2015-02-28') as addDayDate
FROM t_agreement a
LEFT JOIN t_agreement_project ap ON a.id = ap.agreement_id