Hello List,
I am trying to fill in values in a menu by obtaining results from an
SQL query to a datamart called ADW_publish on the server called
Erdbdev03. This is the query I tried executing in the SQL Server
Management Studio in the Erdbdev03 machine:
SELECT distinct b.Subject
FROM ADW_Publish.dbo.F_Class_Exam a, ADW_Publish.dbo.D_Course_Catalog
b
WHERE
(a.Course_ID = b.Course_ID) AND
(a.Term = '2073') AND
(a.Class_Exam_Type = 'FIN') AND
(b.Term = '2073')
ORDER BY b.Subject
The SQL command I entered in Remedy's menu is:
SELECT distinct b.Subject
FROM [EMAIL PROTECTED] a,
[EMAIL PROTECTED] b
WHERE
(a.Course_ID = b.Course_ID) AND
(a.Term = '2073') AND
(a.Class_Exam_Type = 'FIN') AND
(b.Term = '2073')
ORDER BY b.Subject;
When I try to access the menu, it gives me this error:
"Failure during SQL operation to the database:
ORA-00933: SQL command not properly ended (ARERR 552)"
Before, this query used to work when it was still pointing to an old
database:
SELECT distinct clas_name
FROM [EMAIL PROTECTED]
WHERE exam_session = '$536870994$'
This query and the ones above generate the same results, except now we
are pointing to a newer database.
Any thoughts?
Thanks,
Mikhail
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
