PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
SELECT First_Name, Last_Name, Department_Name, suapp.FACULTY.Faculty_UUID
, Faculty_Email, Faculty_Title, Faculty_Profile_Link FROM suapp.FACULTY
JOIN (SELECT DISTINCT
Topic_Code = suapp.AREA_TOPIC.Area_Topi c_Code
c_Code = 'CD-a'
) rm ON suapp.FACULTY.Faculty_UUID
= rm.Faculty_UUID ORDER BY suapp.FACULTY.Last_Name, suapp.FACULTY.First_Name;
An expression of non-boolean type specified in a context where a condition is expected, near 'WHERE'.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.