Here is a sample of Crystal SQL:
FROM
"IGSVIEW"."FINANCIAL_CUSTOM" FINANCIAL_CUSTOM RIGHT JOIN "IGSVIEW"."IS_INVENTORY" ON FINANCIAL_CUSTOM."IS_INVENTORY_ID" = IS_INVENTORY."IS_INVENTORY_ID"
INNER JOIN "IGSVIEW"."ORGANIZATION" ORGANIZATION ON IS_INVENTORY."ORGANIZATION_ID" = ORGANIZATION."ORGANIZATION_ID"
INNER JOIN "IGSVIEW"."LOCATION" LOCATION ON IS_INVENTORY."LOCATION_ID" = LOCATION."LOCATION_ID"
INNER JOIN "IGSVIEW".ART_FLEX ART_FLEX RIGHT JOIN "IGSVIEW".IS_INV_PHY IS_INV_PHY ON ART_FLEX."ASSET_TAG" = IS_INV_PHY."ASSET_TAG" ON IS_INVENTORY."ASSET_TAG" = IS_INV_PHY."ASSET_TAG"
INNER JOIN "IGSVIEW".ORGANIZATION ORGANIZATION AS ORGANIZATION_1 ON IS_INV_PHY."ORGANIZATION_ID" = ORGANIZATION_1."ORGANIZATION_ID"
INNER JOIN "IGSVIEW".LOCATION LOCATION AS LOCATION_1 ON IS_INV_PHY."LOCATION_ID" = LOCATION_1."LOCATION_ID"
INNER JOIN "IGSVIEW".PEOPLE PEOPLE ON IS_INV_PHY."PEOPLE_ID" = PEOPLE."PEOPLE_ID"
I'm trying to alias some tables in order to get the correct data. The AS statements (near the end) fail with a
(database is IBM DB2)
SQL0199N The use of the reserved word AS following "" is not valid. Expected tokens include ON FULL LEFT INNER RIGHT". SQLSTATE=42601.
Any help is greatly appreciated.
FROM
"IGSVIEW"."FINANCIAL_CUSTOM" FINANCIAL_CUSTOM RIGHT JOIN "IGSVIEW"."IS_INVENTORY" ON FINANCIAL_CUSTOM."IS_INVENTORY_ID" = IS_INVENTORY."IS_INVENTORY_ID"
INNER JOIN "IGSVIEW"."ORGANIZATION" ORGANIZATION ON IS_INVENTORY."ORGANIZATION_ID" = ORGANIZATION."ORGANIZATION_ID"
INNER JOIN "IGSVIEW"."LOCATION" LOCATION ON IS_INVENTORY."LOCATION_ID" = LOCATION."LOCATION_ID"
INNER JOIN "IGSVIEW".ART_FLEX ART_FLEX RIGHT JOIN "IGSVIEW".IS_INV_PHY IS_INV_PHY ON ART_FLEX."ASSET_TAG" = IS_INV_PHY."ASSET_TAG" ON IS_INVENTORY."ASSET_TAG" = IS_INV_PHY."ASSET_TAG"
INNER JOIN "IGSVIEW".ORGANIZATION ORGANIZATION AS ORGANIZATION_1 ON IS_INV_PHY."ORGANIZATION_ID" = ORGANIZATION_1."ORGANIZATION_ID"
INNER JOIN "IGSVIEW".LOCATION LOCATION AS LOCATION_1 ON IS_INV_PHY."LOCATION_ID" = LOCATION_1."LOCATION_ID"
INNER JOIN "IGSVIEW".PEOPLE PEOPLE ON IS_INV_PHY."PEOPLE_ID" = PEOPLE."PEOPLE_ID"
I'm trying to alias some tables in order to get the correct data. The AS statements (near the end) fail with a
(database is IBM DB2)
SQL0199N The use of the reserved word AS following "" is not valid. Expected tokens include ON FULL LEFT INNER RIGHT". SQLSTATE=42601.
Any help is greatly appreciated.