假如表一(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 --哪位高手能够帮小弟我解决这一难题啊?感激不尽!在线等待中...
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 --哪位高手能够帮小弟我解决这一难题啊?感激不尽!在线等待中...
from table2 left join table1 using(tid)
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`