因此,这会生成21行数据,但我希望它显示实际计数为21。有什么想法/建议吗?
SELECT * FROM PRODUCT left join VENDOR ON PRODUCT.V_CODE = VENDOR.V_CODE
UNION
SELECT * FROM PRODUCT RIGHT JOIN VENDOR ON PRODUCT.V_CODE = VENDOR.V_CODE;
因此,这会生成21行数据,但我希望它显示实际计数为21。有什么想法/建议吗?
SELECT * FROM PRODUCT left join VENDOR ON PRODUCT.V_CODE = VENDOR.V_CODE
UNION
SELECT * FROM PRODUCT RIGHT JOIN VENDOR ON PRODUCT.V_CODE = VENDOR.V_CODE;