AnsweredAssumed Answered

Course Listing With Instructor Names Query

Question asked by George.Finkle on Feb 23, 2017
Latest reply on Feb 23, 2017 by bs28666

I need a query that gives me:  COURSE_ID, COURSE_NAME, DTCREATED, DTMODIFIED, AVAILABLE_IND. . . . that part I can do, however, I need instructor data, so, I guess I need to add in a join that brings users with the rights greater than XX, and include USER_ID, BATCH_UID, ROLE NAME, FIRSTNAME, LASTNAME, EMAIL....  Can someone help with writing the query?  Thank you.  George Finkle, Henderson State University.