As a follow on from my previous question (accepted before asking this!), how could I do an inner join on the status?
The dbo.Users.Status will be 7, but in the UsersTypes table 7 means "Administrator". How can I do a join for my where clause so that if the status number (which is a row ID) ever changes it won't cause an issue. EG having something like:
WHERE(dbo.Users.Status = dbo.UsersTypes.Code = "Administrator"
Or however you would do a join on that.