ActiveRecord多表查詢

當from中有多個表時,而select 中只需要一個表中的所有資料,不必像sql一樣用*,只要把類名寫出來就行,摸索出來的經驗,記下,希望對大家有協助.

見下面查詢,特別是加紅部分.

       [DataObjectMethod(DataObjectMethodType.Select)]
        public static ZjcXueshenghuojiang[] List(int xuenian, int xueqi,long banjiId,long banjiStudentId)
        {
            //BaseBanjiStudent stu = new BaseBanjiStudent();
            //stu.BanjiStudentid

            string strHql = @"Select huojiang from ZjcXueshenghuojiang huojiang , BaseBanjiStudent stu ";
            strHql += " where huojiang.Xuenian = :xuenian and huojiang.Xueqi = :xueqi ";
            strHql += " and  huojiang.BanjiStudentId = stu.BanjiStudentid  and stu.BaseBanji.Banjiid = :banjiId ";
            //    strHql += " order by huojiang.StartDate DESC ";
            SimpleQuery query = new SimpleQuery(
                typeof(ZjcXueshenghuojiang), strHql);
            query.SetParameter("xuenian", xuenian);
            query.SetParameter("xueqi", xueqi);
            query.SetParameter("banjiId", banjiId);
            return (ZjcXueshenghuojiang[])ExecuteQuery(query);
        }