SQL连接与左外部连接

I'm trying to fetch an extra column from a table with a join query on one of the table which are in left outer join,I'm trying to fetch an extra column from a tabl