Skip to Content
0
Jul 09, 2019 at 04:54 PM

Subqueries in SQL Command

75 Views

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