I have a query which essentially joins names and email addresses out of several tables. The query joins correctly if you do not include the final join and I can't figure out why.
SELECT tbl_Session.*, tbl_agent.Agent_Email, tbl_team_mgr.TM_Name, tbl_team_mgr.TM_Email, tbl_NHD.NHD_Name...