Question

sql="select P.*,T.name as Typename from tb_function P inner join tb_Type ......

sql="select P.*,T.name as Typename from tb_function P inner join tb_Type T on P.Type= T.ID where P.Type="&rs_Type("ID")&" order by P.hit desc"
请帮忙详细解释这句话的意思。谢谢！！！

Answer 1

就是一个sql语句。它的意思是：
tb_function表和tb_Type表内连接条件是：P.Type列值等于rs_Type("ID")，按p.hit列倒序。

Answer 2

SELECT P.*, T.Name AS TypeName
FROM tb_Function AS P
INNER JOIN tb_Type AS T
ON (P.Type = T.ID)
WHERE (P.Type = " & rs_Type("ID").Value & ")
ORDER BY P.Hit DESC

其实就是这么一个SQL语句，P、T两表连接，返回类别是rs_Type("ID").Value的P表的全部字段和T.Name，并按照P.Hit字段排序。