How to implement a join union query for multiple tables

There are currently 3 tables a B C

The demand is a and B inline query results, and then leftist c table (c data is not complete)

My wording is

SELECT * from a B left JOIN C on a.id=c.id WHERE a.id=b.id ORDER by ID

Although there is no error, but the result is wrong ...

How do I write a statement to find out the right results?

Reply content:

There are currently 3 tables a B C

The demand is a and B inline query results, and then leftist c table (c data is not complete)

My wording is

SELECT * from a B left JOIN C on a.id=c.id WHERE a.id=b.id ORDER by ID

Although there is no error, but the result is wrong ...

How do I write a statement to find out the right results?

Self-addressed:
SELECT * from A left JOIN C on a.id=c.id INNER JOIN B on B.id=a.id

