求sql语句

[superren]

有两表：
table1(id ,name),table2(id ,parentID , name)
table2是子表，其中parentID为table1的id
数据如下：
table1:
[id] [name]
1 a
2 b
3 c

table2:
[id] [parentID] [name]
1 1 名字1
2 1 名字2
3 2 名字3
4 3 名字4
5 2 名字5
6 3 名字6

想用一条sql 语句求出下面的结果：

result:
[table_name] [id] [name]
table1 1 a
table2 1 名字1
table2 2 名字2
table1 1 b
table2 3 名字3
table2 5 名字5
table1 3 c
table2 4 名字4
table2 6 名字6

不知各位高人有否可参考的例子呢？小弟在这里谢啦

[good2speed]

http://www.cnblogs.com/goodspeed/archive/2004/09/16/43714.html

[goregrypeck]

xue xi

[superren]

用查询语句可不可以啊？不想用函数

[dulei115]

select tablename, id, name
from (select 'table1' as tablename, id as id, id as parentId, name
from table1
union
select 'table2' as tablename, id, parentid, name)
order by parentid, tablename

[dulei115]

再改一下，试试
select tablename, id, name
from (select 'table1' as tablename, id as id, id as parentId, name
from table1
union
select 'table2' as tablename, id, parentid, name)
order by parentid, tablename, id