Question - SQL 'FROM' 1

[jpeters01]

Hi, I am a Crystal report writer trying to create a Crystal report based off of a SQL that I was given. The report pulls from an oracle database. I am trying to add the tables from this FROM statement to my Crystal report.

FROM
O_ITEM,
O_PAT,
ent_config.STAFF O_STAFF-AUTHORIZE,
PRIORITY,
O_PROMPT O_PROMPT_RESP,

I am not familiar with this Syntax and am trying to figure out what it means, specifically I am having trouble with 'ent_config.STAFF O_STAFF-AUTHORIZE,'. I can find the end_config.STAFF table in the database, but I do not see 'O_STAFF_AUTHORIZE'. And, I can find the 0_PROMPT table, but I don't see O_STAFF_AUTHORIZE.

Help would be very much appreciated!

Thanks,

Jan

 

[johnherman]

It is possible that you (your user account and/or group) does not have permissions to SELECT from that table. Security/permissions is the first place I would investigate, esp since you can see other tables in ent_config.

==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than agile big data clouds)

 

[TamarGranor]

O_STAFF-AUTHORIZE and O_PROMPT_RESP are local aliases, names used for the respective tables only within that query. However, I don't know how that translates to Crystal.

Tamar

 

[jpeters01]

I appreciate both of your replies. Tamar, I found out that you are correct...Thank you!!