我希望显示与文件夹相关的数据,即使相关表不包含数据。
SELECT *
FROM FOLDER fold
-- Other joins skipped for brevity
-- Display null values if no data found in INVOICE items
LEFT OUTER JOIN INVOICE inv -- Works if INNER JOIN, but I need OUTER
ON inv.DOS_CODE_ID = fold.dos_code_id
AND inv.ECO_COD