表间连接联合查询表间左连接 联合查询

StringBuffer sb = new StringBuffer("select t.id ,t.NAME,vendor_id,sort,longdesc ,VERSION ,os_id ,install_script,uninstall_script,status,create_time,G.NAME categoryname from"
                + " (SELECT A.ID,NAME,VENDOR_ID,SORT,LONGDESC,F.VERSION,F.OS_ID,INSTALL_SCRIPT,UNINSTALL_SCRIPT,F.STATUS,F.CREATE_TIME  FROM APP A,APP_FILE F"
                + " where F.APP_ID=A.ID  and $like(NAME,app_name) and  $equal(A.ID,app_id) )t "
                + "  LEFT JOIN   category_app_rel c  ON t.id = c.app_id  LEFT JOIN  category G  ON c.c_id = G.id "
                
        );
        /*sb.append(" and $like(NAME,app_name)");
        sb.append(" and  $equal(A.ID,app_id)");*/
        
        sb.append("order by t.CREATE_TIME DESC");
        return db.getListResultByPage(bus, new SqlInfo(String.valueOf(sb)));