We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Add a JOIN clause to a SQL statement variable
Appends a JOIN to the given SQL statement variable. The join type, table, and clause are required; the hint is optional.
| Parameter | Description |
|---|---|
| cmd | SQL statement variable name |
| Argument 0 | join type (e.g. INNER, LEFT, LEFT OUTER) |
| Argument 1 | table name to join |
| Argument 2 | join condition (ON clause) |
| Argument 3 | join hint (optional, e.g. NOLOCK) |
SqlStatement.AddJoin "SQL statement variable name", "join type (e.g. INNER, LEFT, LEFT OUTER)", "table name to join", "join condition (ON clause)", "join hint (optional, e.g. NOLOCK)"