帮我写select 语句-----在线等待答案
tenny 2004-07-23 11:34:21 存在两个表:
table1:(有两个字段,共有m行数据,id不可以重复的)
name = a
______________
id value
______________
7 2
8 3
9 4
. 5
. 6
. 5
m 9
______________
table2:(n列,1行数据)
name = b
_____________________________________
id pos1 pos2 pos3 .... posn
_____________________________________
1 7 8 9 m
使用select 语句和联结得出下列结果(表头为b表的表头,值为b表对应
pos列的值在a表id列中出现的id对应的value):
_____________________________________
id pos1 pos2 pos3 .... posn
_____________________________________
1 2 3 4 .... 9