sql语句

SELECT I1, I2 , I3 , I4 , I5 ,
      I6 , I7, I8 , I9 , tb1.res_id
FROM tb1 LEFT OUTER JOIN
      tb3 ON tb1.res_id = tb3.res_id LEFT OUTER JOIN
      tb2 ON tb1.res_id = tb2.res_id

union

SELECT I1, I2 , I3 , I4 , I5 ,
      I6 , I7, I8 , I9 , tb2.res_id
FROM tb2 LEFT OUTER JOIN
      tb1 ON tb2.res_id = tb1.res_id LEFT OUTER JOIN
      tb3 ON tb2.res_id = tb3.res_id

union

SELECT I1, I2 , I3 , I4 , I5 ,
      I6 , I7, I8 , I9 , tb3.res_id
FROM tb3 LEFT OUTER JOIN
      tb1 ON tb3.res_id = tb1.res_id LEFT OUTER JOIN
      tb2 ON tb3.res_id = tb2.res_id