Query of Queries support two string concatenation operators: + and ||, as the following examples show:
LASTNAME + ', ' + FIRSTNAME LASTNAME || ', ' || FIRSTNAME
View comments in LiveDocs