/// <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);
}
///// <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);
}
/// <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);
}
/// <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);
}