總帳========

[Admin]

SELECT m.mbet001, m.mbet005, m.mbet006, sum( d.mbetd015 ) , sum( b.bet003 )
FROM `membet2` AS m, mbetdetial2 AS d
LEFT JOIN `bettingresult2` AS b ON b.bet001 = m.mbet001
AND d.mbetd002 = b.bet002
WHERE m.mbet002 =29
AND m.mbet004 = '020288'
AND m.mbet001 = d.mbetd001
AND d.mbetd006
IN ( 38, 39, 42, 43 )
GROUP BY m.mbet001
LIMIT 0 , 30