4D Doc Center : subquery

4D v12.1

subquery



	Command subquer SELECT [ALL \| DISTINCT] {* \| select_item, ..., select_item} FROM table_reference, ..., table_reference [WHERE search_condition] [GROUP BY sort_list] [HAVING search_condition] [LIMIT {int_number \| ALL}] [OFFSET int_number]

Description

A subquery is like a separate SELECT statement enclosed in parentheses and passed in the predicate of another SQL statement (SELECT, INSERT, UPDATE or DELETE). It acts as a query within a query and is often passed as part of a WHERE or HAVING clause.