Solar_Sql_Select::fromSelect()

public Solar_Sql_Select Solar_Sql_Select::fromSelect ( string|Solar_Sql_Select $spec , string $name , array|string $cols = '*' )

Adds a sub-select and columns to the query.

Parameters

  • (string|Solar_Sql_Select) $spec: If a Solar_Sql_Select object, use as the sub-select; if a string, the sub-select command string.

  • (string) $name: The alias name for the sub-select.

  • (array|string) $cols: The columns to retrieve from the sub-select; by default, '*' (all columns). This is unlike the normal from() and join() methods, which by default select no columns.

Returns

  • (Solar_Sql_Select)

Description

Adds a sub-select and columns to the query.

The format is "FROM ($select) AS $name"; an alias name is always required so we can deconflict columns properly.



Local