[SQL ] 關於三個table group by

看板Database作者tn801534 (踢恩)時間15年前 (2011/01/14 17:00)推噓1(1推 0噓 3→)

留言4則, 3人參與討論串1/1

因為目前系統是使用mysql4 沒有子查詢功能 SELECT A.*,AVG(point) avgPoint FROM A LEFT JOIN B ON A.id = B.id GROUP BY A.id ORDER BY avgPoint SELECT A.*,SUM(click) sumClick FROM A LEFT JOIN C ON A.id = C.id GROUP BY A.id 請問這兩個SQL在不生級mysql的情況下有辦法一次做完嗎因為我可能會用到sumClick排序 SELECT A.*,AVG(point) avgPoint,SUM(click) sumClick FROM A LEFT JOIN B ON A.id = B.id LEFT JOIN C ON A.id = C.id GROUP BY A.id 上面這樣做sumClick會被重複算到不正確希望有高手能幫我解決~~ 萬分感謝~~~~ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 211.20.224.10

→

kylekai

01/14 17:31, , 1^F

01/14 17:31, 1^F

→

tn801534

01/15 14:44, , 2^F

01/15 14:44, 2^F

※ tn801534:轉錄至看板 Web_Design 01/15 14:45

推

danielguo

01/18 07:15, , 3^F