In the third part of the SELECT statement, we can also use several possibilities. These possibilities may include the following:
- INTO: When we choose this, we can select fields to structure. An example can be found in the explanation of SELECT SINGLE.
- INTO CORRESPONDING FIELDS OF: We can also use this addition, but, during SELECT, the system tries to select and match fields corresponding to data elements in a result. The differences in the results will be shown in the example.
- INTO [ obj1, obj2 ... ]: We can select fields in relation to a given variable. For example, if we want to select the carrid and connid fields, we can select these fields directly in relation to a variable ...