MYSQL查询左连接显示来自一个表的所有数据

SELECT 
A.CODE,
B.NOTE,
C.NUMBER

FROM (A
LEFT JOIN B
ON A.CODE = B.CODE
LEFT JOIN C
ON A.CODE = C.NUMBER
)

WHERE C.ID = B.ID 
SELECT 
A.CODE,
B.NOTE,
C.NUMBER

FROM (A
LEFT