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: 188.8.131.521
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