Administer > Database Administration > Data persistence > Queries > Cross-table join query improvements > Cross-table join query examples and use cases

Cross-table join query examples and use cases

The following examples detail various scenarios in which you will see the benefits of the cross-table join queries:

Note The table alias are mandatory for cross-table query. For example, select pro.* from probsummary pro is correct, whereas select probsummary.* from probsummary is incorrect.

Reserved words

Reserved words have a special meaning in Service Manager that is defined in RAD. These special words can only be used for that purpose. Do not use them for any other purpose such as field names or table alias. The following is an alphabetical list of reserved words:

AND, BEGIN, DO, ELSE, END, FALSE, FOR, IF, IN, ISIN, NOT, NULL, OR, STEP, WHILE, THEN, TRUE, UNKNOWN, INNER, OUTER, JOIN, ON, SELECT, AS, FROM, WHERE, ASC, DESC, BETWEEN, GROUP, BY, HAVING, LIKE, TABLE, VIEW, WHERE, MIN, MAX, AVG, COUNT, SUM, ID.

In addition, all the RAD and JavaScript function names, and standard SQL reserved word in Oracle, SQL Server, or DB2 are similarly reserved.