gistfile1.txt

SELECT        dbo.UserGroupsTbl.UserGroupName, dbo.UsersTbl.UserID, dbo.UsersTbl.FullName, dbo.UsersTbl.UserName, dbo.UsersTbl.Password, dbo.UsersTbl.OrganisationID, dbo.UsersTbl.Email, dbo.UsersTbl.Active, 
                         dbo.UsersTbl.LoggedIn, dbo.UsersTbl.LastLogin, dbo.UsersTbl.NonDMZAccess, dbo.UsersTbl.DMZAccess, dbo.UsersTbl.EmailUser, dbo.UsersTbl.DateModified, dbo.UsersTbl.DateCreated, 
                         dbo.UsersTbl.FailedAttempt, dbo.UsersTbl.AccountLocked, dbo.LinkUsersGroupsTbl.UserGroupID, dbo.UserTypesTbl.UserType, dbo.UsersTbl.UserGUID, dbo.tblClientDetails.dteDateofBirth, 
                         dbo.tblClientDetails.strClientFirstName, dbo.tblClientDetails.strClientSurname, dbo.tblClientDetails.ClientID
FROM            dbo.LinkUsersGroupsTbl INNER JOIN
                         dbo.UserGroupsTbl ON dbo.LinkUsersGroupsTbl.UserGroupID = dbo.UserGroupsTbl.UserGroupID INNER JOIN
                         dbo.UsersTbl ON dbo.LinkUsersGroupsTbl.UserID = dbo.UsersTbl.UserID INNER JOIN
                         dbo.UserTypesTbl ON dbo.UsersTbl.UserTypeID = dbo.UserTypesTbl.UserTypeID INNER JOIN
                         dbo.tblClientDetails ON dbo.LinkUsersGroupsTbl.UserID = dbo.tblClientDetails.UserID
WHERE        (dbo.UserGroupsTbl.Deleted = 0) AND (dbo.UsersTbl.Deleted = 0) AND (dbo.UserTypesTbl.UserType = 'Client')