subquery

Home

4D v17

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]

Beschreibung

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.

Siehe auch

search_condition
SELECT
select_item
sort_list
table_reference