Just to make it clear for you. See the "Select statement" article in the Dev Guide:
Цитата:
Field select
It is also possible to use a select statement in a lookup on a field. After a select statement that fetched a record in a table, you can write .field name to reference a field in the table.
Notice the difference between the normal select and the field select. The field select operates directly on a table, whereas the select statement operates on a table variable.