Originally Posted by
notsirk
Hello! I am new to SQL so bear with me.
. . . E t c . . .
But I keep getting the following error message but I don't understand how there could be any problem with my FROM statement:
Is there any way anyone could explain what this message is even telling me?
That error is telling you the code has "syntax" errors.
Database objects (vg. table names / column names) normally do not have "spaces" in the name.
Many of these reporting tools have a "dictionary" which translates the database object names into "user friendly" names.
Look for this dictionary to locate the "real" database names being used.
Also, what may appear as a single table in the tool, may be in reality a complex "view".
As a developer you have the right to be provided with the structure and any other information necessary to do your job.
If you cannot obtain this information, you may need to escalate the issue with your manager.
Good luck!
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote
