Thanks for your help and patience. You've helped me before and I know you know your stuff; unfortunately, I can't say the same for me.
- - - -
No, the user isn't logged in here; the administrator is. Although I have many pages where I need to do a similar join, this specific page is my admin_visitorDetail page.
The two tables are:
visitors
VisitorID
VisitorGroupID
groups
GroupID
GroupName
The details page is showing the data from the visitors table which means for visitors.VisitorGroupID - it displays groups.GroupID. I want it to display the GroupName.
The code I have above (not that I'm married to it) shows the groups.GroupName ok - but it shows all of them from every record in the groups table. I just need it to return the single GroupName for the GroupID that is stored in the visitors.VisitorGroupID column.