Use

You should use non-standard multiple operations to either:

• retrieve attributes from multiple database tables, performing a relational join across the tables, or;
• retrieve attributes from one or more database tables when the selection criteria is too complex to use a readmulti or nsreadmulti. For example, if thewhere clause contains comparisons other than equals such as less-than, greater-than, etc.

A non-standard multiple operation is very similar (from a modeling perspective) to a non-standard multiple read operation (nsreadmulti). The major difference is that the designer must specify the SQL to be executed. This enables multiple database tables to be referenced and/or complexwhere clauses to be specified.