Skip to content

Instance Property

tables

One or more tables to include as sources for data to retrieve.
var tables: [any SQLExpression]

Discussion

This array rarely contains more than one element; when multiple tables are specified by this property, they are included in the resulting query via the comma operator, effectively creating a CROSS JOIN (Cartesian product); if not filtered by the predicate, this can result in extremely slow and expensive queries. It is almost always preferable to specify all but the first source table in the joins array.