①SELECT A.ASSETSCODE,B.ASSETSNAME FROM ASSETSTABLE AS A,ASSETSNAME AS B
WHERE A.ASSETSNAMEID=B.ID ORDER BY B.ASSETSNAME②SELECT ASSETSCODE,(SELECT ASSETSNAME FROM ASSETSNAME
WHERE ID = ASSETSTABLE.ASSETSNAMEID) AS ASSETSNAME FROM ASSETSTABLE ORDER BY ASSETSNAME两个查询的结果完全是一样的,不知道哪个效率会高一些,谢谢!!
WHERE A.ASSETSNAMEID=B.ID ORDER BY B.ASSETSNAME②SELECT ASSETSCODE,(SELECT ASSETSNAME FROM ASSETSNAME
WHERE ID = ASSETSTABLE.ASSETSNAMEID) AS ASSETSNAME FROM ASSETSTABLE ORDER BY ASSETSNAME两个查询的结果完全是一样的,不知道哪个效率会高一些,谢谢!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货