如果根本另一个表的内容进行排序.....

[auly403]

表A有 字段[BNO]---int;
表B有 字段[index]-----int.. 字段[name]----字符

其中表A的字段[BNO]与表B的字段[index]对应..

再进行表A进行查找时..如何能让结果根据表B的字段[name]进行排序....

[auly403]

up

[菜牛]

SELECT * FROM [A],[B] WHERE [A].[BNO]=[B].[index] ORDER BY [B].[name]

[auly403]

iQueryString:='select * from typelist,brand where typelist.[brand]=brand.[no] and typelist.'+combobox1.text+' like ''%'+edit1.Text+'%'' order by brand.[name] asc, ['+ szFieldName +'] asc';

[auly403]

iQueryString:='select * from typelist,brand where typelist.[brand]=brand.[no] order by brand.[name] asc';