mysql ºÏ²¢

ÓÐÒ»¸öÎÊÌâ
a±í
name money month
ak    50  2009-10-11
bi    20  2009-10-10
ak    30  2009-10-15

b±í
name shou  month
ak    30  2009-10-18
ak    20  2009-10-20

a±íÊÇÏúÊÛ ak ÏúÊÛÁË80Ôª
b±íÊÇÊÕÇ® ak ÊÕÁË50Ôª
ÎÒÏëÖªµÀÔõôÔÚÒ»ÐÐÖÐÏÔʾÏúÊÛÁË80Ôª ºÍÏÔʾÁË50Ôª ÎÒÓÃleft join ²»ÁË~~~~~~~~~~
name  money  shou  month
ak      80    50  2009-10
bi      20    0  2009-10

---

¿ÉÒÔÏêϸһЩÂð£¿Ð»Ð»£¡

---

ÔÚÏߵȣ¡£¡£¡£¡

---

select c.name,c.money,d.shou,left(c.month,7) from ((select name,sum(money) as money,month from a group by name,left(month,7))c left join (select name,sum(shou) as shou,month from b group by name,left(month,7)) d on c.name=d.name and c.month=d.month)

---

Ìáʾ錯誤~~~~~~~~~~
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\test\z.php on line 4

---

ÊÇ·ñÒª½¨個c±íºÍd±í~~~~~~~~~~~

---

okÁË£¬£¬´ò錯×Ö~~~~~£¬ºÇºÇ謝謝£¬結貼£¡£¡£¡£¡