【急】两张表合并成一张一表的问题

[linjch520]

假如表一(table1)是：
tid name
1 ss
2 ff
6 ee

表二是(table2)：
tid tnumber
1 5
2 5
3 5
4 5
5 5
6 5
7 5

要求合成的表(table3)为
tid tnumber name
1 5 ss
2 5 ff
3 5 --
4 5 --
5 5 --
6 5 ee
7 5 --

哪位高手能够帮小弟我解决这一难题啊？感激不尽！在线等待中...

[linjch520]

急啊，求解决！

[linjch520]

已经解决！

[ACMAIN_CHM]

[ACMAIN_CHM]

select tid,tnumber,name
from table2 left join table1 using(tid)

[lin520]

自己写了一个：
select `t`.`tid` AS `tid`,`t`.`mnumber` AS `mnumber`,`t`.`snumber` AS `snumber`,`t`.`tleader` AS `tleader`,`t`.`tname` AS `tname`,`t`.`title` AS `title`,group_concat(concat(concat(`s`.`name`,' ')) separator ', ') AS `members`,`t`.`torder` AS `torder` from (`team` `t` left join `students` `s` on((`t`.`tid` = `s`.`tid`))) group by `t`.`tid`