SQL语言转换Access语言

Question

SELECT COUNT(*) cus_all       -- 총 고객수
        , SUM((CASE WHEN B.cid IS NULL THEN 0 ELSE 1 END)) cus_ord  --주문한 고객수
        , SUM((CASE WHEN B.cid IS NULL THEN 1 ELSE 0 END)) cus_non  -- 주문하지 않은 고객수
  FROM customers A
LEFT JOIN (SELECT DISTINCT cid FROM orders) B
     ON A.cid, B.cid

SELECT COUNT(DISTINCT c.cid) AS '모든고객수'

, COUNT(DISTINCT (CASE WHEN o.cid IS NOT NULL THEN c.cid ELSE NULL END)) AS '주문을한번이상'

, COUNT(DISTINCT (CASE WHEN o.cid IS NULL THEN c.cid ELSE NULL END)) AS '주문한적없는'

FROM customers c

LEFT OUTER JOIN orders o

ON o.cid = c.cid;

老师给了这两个语言做参考，转换成Access可用的语言需要怎么转换啊，求大神指导

Answer 1

access用的语法基本都一样，可以直接移植到程序中使用，看看是否报错，根据提示进行调整。