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 |