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 .
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"
答
就是一个sql语句.它的意思是:
tb_function表和tb_Type表内连接条件是:P.Type列值等于rs_Type("ID"),按p.hit列倒序.