Julias99
دوشنبه 03 آذر 1393, 10:50 صبح
سلام دوستان من کوئری زیر رو نوشتم اما نتیجه ای که نشون میده دو بار بسته به تعداد روزهای انتخاب شده نمایش میده
SELECT t2.Advertise, COUNT(t1.callin) AS Count FROM Customer_TB AS t1 LEFT OUTER JOIN Advertise_TB AS t2 ON t1.callin = t2.Id GROUP BY t2.Advertise, t1.regdate HAVING (t1.regdate BETWEEN '1393/09/01' AND '1393/09/03')
اینم چیزی که نشون میده :
125999
SELECT t2.Advertise, COUNT(t1.callin) AS Count FROM Customer_TB AS t1 LEFT OUTER JOIN Advertise_TB AS t2 ON t1.callin = t2.Id GROUP BY t2.Advertise, t1.regdate HAVING (t1.regdate BETWEEN '1393/09/01' AND '1393/09/03')
اینم چیزی که نشون میده :
125999