Examples
Overload List
Name | Description | |
---|---|---|
![]() | Join(String, String, Collection<(Of <<'(CCondition>)>>), eJoinType) |
JOIN two tables together with an alias based on a collection of conditions
|
![]() | Join(String, String, CCondition, eJoinType) |
JOIN two tables together with an alias based on a CCondition
|
![]() | Join(String, String, eOperator, Object, eJoinType) |
JOIN two tables together based on a relationship of a column and data
|
![]() | Join(String, String, eOperator, String, String, eJoinType) |
JOIN two tables together based on a relationship of columns
|
Examples

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