你别用内连接查询 你这样试下 SELECT CATAGORYNAME,PRODUCTNAME,PERCOUNT,STORAGE FROM CATAGORY AS C,PRODUCT AS P WHERE C.CATAGORYID=P.CAT_CATAGORYID;
展开全部
收起
热心网友回答时间:2024-04-27 21:41
把双引号全部去掉:
select CATAGORY.CATAGORYNAME,PRODUCT.PRODUCTNAME,PRODUCT.PERCOUNT,PRODUCT.STORAGE FROM CATAGORY INNER JOIN PRODUCT ON CATAGORY.CATAGORYID=PRODUCT.CAT_CATAGORYID;