Oh, and I also tried the query without the semi-colon and it still did not work:
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 On Jun 12, 11:01 am, Mikhail <[EMAIL PROTECTED]> wrote: > 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 atwww.arslist.orgARSlist:"Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
