table 1 (상품내역)         taable2(판매내역)                                    출력양식

  no   name             day                       no     su                     번호         상품명           판매현황

  1      축구공           2011-03-02              1          2               1              축구공                 7

  2      농구공           2011-03-02              1          5               2             농구공                 0

  3.     배구공          2011-04-02               3          3               3               배구공                3

  4      야구공                                                                       4              야구공                 0

 판매현황이 없는자료는 빼면 간단한데   

  select   a.no,b.name,sum(su)  from table1  a  left join  table2  b on a.no=b.no

0인 현황도 나올려면 어떻게 해야 하는지 문장하나로 안되나요