SELECT
RE_Customers.cCustomerName, RE_CustomerClasses.cClassName, RE_Customers.cCustomerPhone, RE_Customers.cCustomerMobile
FROM
RE_Customers INNER JOIN RE_CustomerClasses ON RE_Customers.cClassCode = RE_CustomerClasses.cClassCode
ORDER BY cCustomerName DESC
数据库中的数据才几万条执行速度居然要用6秒多...郁闷哪位老大可以帮我改改吗?
參考答案:SELECT RE_Customers.cCustomerName, RE_CustomerClasses.cClassName, RE_Customers.cCustomerPhone, RE_Customers.cCustomerMobile
FROM RE_Customers, RE_CustomerClasses
WHERE RE_Customers.cClassCode =RE_CustomerClasses.cClassCode
ORDER BY cCustomerName DESC
这样试试看