Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jhdalton

  • Rank
  • Birthday 08/24/1984

Profile Information

  • Location
  • Interests
    Halo, Xbox 360, PCs, Counseling, Hiking
  1. Thanks...my terminology may be incorrect, but the joining is not the problem I'm having, really. The problem I'm having is having a column that looks through the multiple employees who match the employee field, but do so in a specific way. To say it another way, I could easily setup a filter that would only show employees who have the profile code "MHP" - but if there isn't someone with the profile code "MHP" then I want it to put someone with the profile code "On Call MHP" and if there isn't anyone with that code, the person with the profile code "LPE" and if that doesn't exist, then put "un
  2. I’m new to writing SQL, and most of my needs so far have been met in the wonderful w3 SQL tutorial. However, I have a desire I haven’t been able to find a way to do, and I can't find info on it in the forums either. I have 3 inner joined tables in the part of the code I’m struggling with. ClientsView EmployeeClients Employees For a given client (identified by ClientsView.client_id) there are many employees linked to the client. I want to search those employees and return in a single column “Primary_Staff” the employee assigned to the client who meets certain criteria. In all cases the fiel
  • Create New...