Examples

Overload List

  NameDescription
Public methodJoin(String, String, Collection<(Of <<'(CCondition>)>>), eJoinType)
JOIN two tables together with an alias based on a collection of conditions
Public methodJoin(String, String, CCondition, eJoinType)
JOIN two tables together with an alias based on a CCondition
Public methodJoin(String, String, eOperator, Object, eJoinType)
JOIN two tables together based on a relationship of a column and data
Public methodJoin(String, String, eOperator, String, String, eJoinType)
JOIN two tables together based on a relationship of columns

Examples

CopyC#
Collection<CCondition>Conditions;

/* 'TableA' is the main table searching against */
WIDB.Search.Table("TableA");

/* Join 'TableX' aliased as 'X' to main table 'TableA' */
/* with condition of TableX.ColumnA == TableX.ColumnB */
WIDB.Search.Join("TableX", "X", new CCondition("ColumnA", eOperator.Equal, "ColumnB"), eJoinType.Left);

/* Join TableX with main table 'TableA' where TableX.ColumnA begins with (LIKE) 'ABC' */
WIDB.Search.Join("TableX", "ColumnA", eOperator.BeginsWith, "ABC", eJoinType.Left);

/* Join TableX with table 'TableZ' where TableX.ColumnA == 'TableZ.ColumnA' */
WIDB.Search.Join("TableX", "ColumnA", eOperator.Equal, "TableZ", "ColumnA", eJoinType.Right);


/* Create search condition 'ColumnA' == 'ColumnB' AND 'ColumnA' == 'ColumnC' */
Conditions = new Collection<CCondition>();
Conditions.Add(new CCondition("ColumnA", eOperator.Equal, "ColumnB"));
Conditions.Add(new CCondition(eLogic.AND));
Conditions.Add(new CCondition("ColumnA", eOperator.Equal, "ColumnC"));

/* 'Join TableY' aliased as 'Y' to main table 'TableA' */
/* with search conditions in Conditions */
WIDB.Search.Join("TableY", "Y", Conditions);

See Also