select A.*,B.* from A left out join B on A.id=B.id; 而不是 select A.*,B.* from A left out join B where A.id=B.id;