例: TABLE A(明細) CUSTMER TYPE 10000 A 10001 A 10002 C TABLE B(類別) TYPE NAME A PIC B MM C KM 用以下SQL好像會有ERROR,不曉要改那 select TYPE,count(TYPE),(select (b.CUSTMER) FROM A a where a.CUSTMER=CUSTMER) from A GROUP BY TYPE 要讓他出來是,以下 TYPE 筆數,NAME A ,2,PIC C ,1,KM

Select B.TYPE, Count(*), B.NAME From A, B Where A.TYPE = B.TYPE Group By B.TYPE, B.NAME

你是用Access嗎?? 也可以試試 Select B.TYPE, Count(*), B.NAME From A Inner Join B On A.TYPE = B.TYPE Group By B.TYPE, B.NAME

Hi vivi666666 SELECT A.TYPE,B.NAME,COUNT(*) FROM TABLEA A LEFT JOIN TABLEB B ON A.TYPE=B.TYPE GROUP BY A.TYPE,B.NAME 應該這樣就可以 Try 一下吧