| Tag | What it means | Required? | |
|---|---|---|---|
| Table | Name of the table to be used. | Yes, unless Count(*) | |
| Synonym | Synonym to be used instead of the table name. If used properly, this can be used to have multiple "copies" of a table in a single query. | No | |
| Field | Name of the field to be used. | Yes, unless Count(*) | |
| As | Synonym to be used instead of the table name. This can be used to put a decent name on special elements, such as ConcatElements or stats. | No | |
| Order | Order in which this item is to be inserted into the query. It is not necessary for the Orders to be sequential. | Yes, and unique, or fields in the output will be overwritten |
| Tag | What it means | Required? | |
|---|---|---|---|
| Table | standard | Yes, unless Count(*) | |
| Syn | standard | No | |
| Field | standard | Yes, unless Count(*) | |
| As | standard | No | |
| GroupSelect | Yes | ||
| Group | Yes | ||
| Order | standard | Yes, and unique, or fields in the output will be overwritten |
| Tag | What it means | Required? | |
|---|---|---|---|
| Table | standard | Yes, unless Count(*) | |
| Syn | standard | No | |
| Value | Value will be added to the SELECT clause exactly as specified. | Yes. |
|
Is operator IS NULL |
Is value empty |
|||||
|
o1 |
o2 |
v |
v1 |
v2 |
valid? |
|
|
Y |
Y |
Y |
Y |
Y |
y |
If both operators are "IS NULL" then the values don't matter |
|
Y |
Y |
Y |
Y |
N |
y |
|
|
Y |
Y |
Y |
N |
Y |
y |
|
|
Y |
Y |
Y |
N |
N |
y |
|
|
Y |
Y |
N |
Y |
Y |
y |
|
|
Y |
Y |
N |
Y |
N |
y |
|
|
Y |
Y |
N |
N |
Y |
y |
|
|
Y |
Y |
N |
N |
N |
y |
|
|
Y |
N |
Y |
Y |
Y |
y |
Value is a fallback - if it has a value, it's OK |
|
Y |
N |
Y |
Y |
N |
y |
|
|
Y |
N |
Y |
N |
Y |
y |
|
|
Y |
N |
Y |
N |
N |
y |
|
|
Y |
N |
N |
Y |
Y |
y |
if both values are provided - all is well |
|
Y |
N |
N |
Y |
N |
n |
missing value is where operator is not a NULL - BAD |
|
Y |
N |
N |
N |
Y |
n |
missing value is where operator is not a NULL - BAD |
|
Y |
N |
N |
N |
N |
n |
nobody has a value and at least on op is not a NULL - BAD |
|
N |
Y |
Y |
Y |
Y |
y |
Value is a fallback - if it has a value, it's OK |
|
N |
Y |
Y |
Y |
N |
y |
|
|
N |
Y |
Y |
N |
Y |
y |
|
|
N |
Y |
Y |
N |
N |
y |
|
|
N |
Y |
N |
Y |
Y |
y |
if both values are provided - all is well |
|
N |
Y |
N |
Y |
N |
y |
missing value is where operator is NULL - all is well |
|
N |
Y |
N |
N |
Y |
n |
missing value is where operator is not a NULL - BAD |
|
N |
Y |
N |
N |
N |
n |
nobody has a value and at least on op is not a NULL - BAD |
|
N |
N |
Y |
Y |
Y |
y |
Value is a fallback - if it has a value, it's OK |
|
N |
N |
Y |
Y |
N |
y |
|
|
N |
N |
Y |
N |
Y |
y |
|
|
N |
N |
Y |
N |
N |
y |
|
|
N |
N |
N |
Y |
Y |
y |
if both values are provided - all is well |
|
N |
N |
N |
Y |
N |
n |
missing value is where operator is not a NULL - BAD |
|
N |
N |
N |
N |
Y |
n |
missing value is where operator is not a NULL - BAD |
|
N |
N |
N |
N |
N |
n |
nobody has a value and at least on op is not a NULL - BAD |