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.