//我有一个这样的sql 选择 x.attr1、p.attr2、p2.attr3、o.attr4、p2.attr5、a2.attr6 来自TABLE_O o RIGHT JOIN TABLE_A aON a.id = o.id AND a.id2 IS NULL 左加入a2.id = o.id和a2.id2 = a.id3上的TABLE_A a2 a.id4 = p.id4上的LEFT JOINid4 IN ( SELECT id3 FROM TABLE_P WHERE TYPE = "anotherText") 和x