Class TJoinItem

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

SQL 1:

select f from t1 left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1

In above SQL, the whole from clause can be represented by a TJoin class.

And "left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1" was represented by 2 instance of class TJoinItem.

These 2 instance can be accessed via JoinItems.

One for: "left join t2 on t1.f1 = t2.f1", the other is "right join t3 on t1.f1 = t3.f1".

public class TJoinItem : TParseTreeNode, Visitable

Inheritance

object

TParseTreeNode

TJoinItem

Implements

Visitable

Inherited Members

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object)

TParseTreeNode.init(object, object, object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.doParse(TCustomSqlStatement, ESqlClause)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Properties

Join

Valid when Kind = join_source_join, means this joinitem start with a join.

public virtual TJoin Join { get; set; }

Property Value

TJoin

JoinHint

public EJoinHint JoinHint { get; set; }

Property Value

EJoinHint

JoinType

public virtual EJoinType JoinType { get; set; }

Property Value

EJoinType

join type of this join, such as left join, right join.

Kind

public virtual int Kind { get; set; }

Property Value

int

OnCondition

public virtual TExpression OnCondition { get; set; }

Property Value

TExpression

Table

Valid when Kind = join_source_table, means this joinitem start with a table. @return

public virtual TTable Table { get; set; }

Property Value

TTable

UsingColumns

public virtual TObjectNameList UsingColumns { get; set; }

Property Value

TObjectNameList

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor