예제 #1
0
        /// <summary>
        /// 内连接
        /// </summary>
        /// <param name="jionTable">表</param>
        /// <param name="on">条件</param>
        /// <returns></returns>
        public KeyWordJoinItem InnerJoin(BQLTableHandle joinTable, BQLCondition on)
        {
            KeyWordJoinItem item = new KeyWordJoinItem(joinTable, on, "inner", this);

            return(item);
        }
예제 #2
0
        ///// <summary>
        ///// 要查询的字段
        ///// </summary>
        //internal BQLTableHandle[] Tables
        //{
        //    get
        //    {
        //        return tables;
        //    }
        //}

        /// <summary>
        /// 左连接
        /// </summary>
        /// <param name="jionTable">表</param>
        /// <param name="on">条件</param>
        /// <returns></returns>
        public KeyWordJoinItem LeftJoin(BQLTableHandle joinTable, BQLCondition on)
        {
            KeyWordJoinItem item = new KeyWordJoinItem(joinTable, on, "left", this);

            return(item);
        }
예제 #3
0
        /// <summary>
        /// 右外连接
        /// </summary>
        /// <param name="jionTable">表</param>
        /// <param name="on">条件</param>
        /// <returns></returns>
        public KeyWordJoinItem RightOuterJoin(BQLTableHandle joinTable, BQLCondition on)
        {
            KeyWordJoinItem item = new KeyWordJoinItem(joinTable, on, "right outer", this);

            return(item);
        }
예제 #4
0
        /// <summary>
        /// 交叉连接
        /// </summary>
        /// <param name="jionTable">表</param>
        /// <param name="on">条件</param>
        /// <returns></returns>
        public KeyWordJoinItem CrossJoin(BQLTableHandle joinTable, BQLCondition on)
        {
            KeyWordJoinItem item = new KeyWordJoinItem(joinTable, on, "cross", this);

            return(item);
        }