SQL LEFT JOIN 怎么使用？高手进

Question

两张表，TABLE AID NAME1 AAA2 BBB3 CCCTABLE BID SOC DATE1 10.1 2013-1-11 12.1 2013 -1-22 9.8 2013-1-12 8.2 2013-1-2希望得到如下结果：ID NAME SOC DATE1 AAA 12.1 2013 -1-22 BBB 8.2 2013-1-23 CCC NULL NULL