table 1
id name grade course
1 t 56 english
1 t 78 math
2 n 67 english
2 n 79 math
3 m 60 english
3 m 80 math
table2
name grade
t 134
n 146
m 140合并后:id name grade course
1 t 56 english
1 t 78 math
2 n 67 english
2 n 79 math
3 m 60 english
3 m 80 math name grade
t 134
n 146
m 140请问怎样使其合并了后,像上面这样?
id name grade course
1 t 56 english
1 t 78 math
2 n 67 english
2 n 79 math
3 m 60 english
3 m 80 math
table2
name grade
t 134
n 146
m 140合并后:id name grade course
1 t 56 english
1 t 78 math
2 n 67 english
2 n 79 math
3 m 60 english
3 m 80 math name grade
t 134
n 146
m 140请问怎样使其合并了后,像上面这样?
数据库用union,反另一个表小了的字段的补空,''就行
select table2(...)
union all
select name grade from table2
)xgroup by x.name