摘要：转自：Evernory查询时生成序号SELECT (SELECT Count([xlh].[aa]) AS AutoNum FROM xlh WHERE (((xlh.aa)<=xlh_Alias.aa));) AS 序号, xlh.aaFROM xlh AS xlh_Alias INNER JOIN xlh ON xlh_Alias.aa=xlh.aaORDER BY xlh.aa;多表sql查询SELECT test.aa AS 第一个字段, test1.bb AS 第二个字段, test1.ccFROM test, test1WHERE test.aa=test1.aa;多表sql 阅读全文