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"
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/08 13:24:47
![sql=](/uploads/image/z/11027552-32-2.jpg?t=sql%3D%22select+P.%2A%2CT.name+as+Typename+from+tb_function+P+inner+join+tb_Type+.sql%3D%22select+P.%2A%2CT.name+as+Typename+from+tb_function+P+inner+join+tb_Type+T+on+P.Type%3D+T.ID+where+P.Type%3D%22%26rs_Type%28%22ID%22%29%26%22+order+by+P.hit+desc%22)
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="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="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列倒序.