How would I go about creating a recordset with two WHERE clauses in it? Basically, I have a list and detail pages for a team assignment. In the list page, there are two fields that have to be concatenated to show full names. In the user table they have different user levels, but I'm having trouble displaying the second field as f_name. Here is my recordset:
SELECT assignment.Id, assignment.Candidate, assignment.`Section`, assignment.Team, assignment.Chaplain, assignment.Reader, tbl_user.Id, CONCAT_WS(' ', `tbl_user`.name_pre, `tbl_user`.name_first, `tbl_user`.name_last, `tbl_user`.name_suffix)AS f_name FROM assignment, `tbl_user` WHERE tbl_user.Id= assignment.Reader
I need to add a second WHERE clause that would be
WHERE tbl_user.Id= assignment.Chaplain
Anyone have any suggestions?