Selection of 2 fields to output as 1 field

You can simply pipe the selection so as to output the 2 or multiple fields into 1 field.

Example
Select FNAME || ' ' || LNAME AS NAME from USERS.

This will output one NAME only.