首先我感觉你这个问题没有讲清楚，不过我还是根据我的理解帮你写一个SQL语句：
select 表2.ID,表1.Name from 表1,表2 into #temp
where 表2.ID = 1 and 表1.NameID = 表2.NameID
declare @ID int,@Name varchar(80),@AllName varchar(800)
declare test_cursor scroll cursor
from select ID,Name from #temp
open test_cursor
declare @I int
set @I = 0
while @i < @@RowsCount
begin
fetch next from test_cursot into @ID,,@Name
set @AllName = @AllName + @Name
set @I = @I + 1
end
close test_cursor
deallocate test_cursor
select @ID,@AllName
adoquery.clear;
selct name from 表1;
adouqery.open;
while not adoquery.eof do
begin
strs:='''+str+'''+adoquery.fieldvalues['name'];
adoquery.next;
end;
然后将名字和序号加入,看能行吗?
