qq_42435514的博客

-- 1 SELECT * FROM SALORDER SA JOIN GCODE GC ON GC.GCODE=SA.GCODE WHERE gc.gname='商品1' ; -- 2 id, gc.gcode,qty,rmb,odate,gname,type select id, gc.gcode,qty,rmb,odate,gname,type from PURORDER PU , GCODE GC , (SELECT count(*) as sum FRO..