Subqueries in SQL Command

Hi,

I'm trying to create a single query in SQL command that contains multiple subqueries. My database is Oracle. What is the syntax to do this in Crystal Report? Thank you.

Crystal Report version: 14.1.2.1121

SELECT ALIAS_TABLE.FULL_NAME
FROM (SELECT USER.FIRST_NAME || ' ' || USER.LAST_NAME AS "FULL_NAME", GROUP.ACCOUNT_TYPE
FROM USER INNER JOIN GROUP ON USER.USERID = GROUP.USERID) AS ALIAS_TABLE