MySQL连接两个查询遇#1142权限错误，请求技术协助

1. 处理权限拒绝错误 (#1142) #

错误提示用户cpses_dikfgmbqhy@localhost没有对AuthorisedLoans.lGroup表的SELECT权限，需由数据库管理员执行以下授权命令：

GRANT SELECT ON AuthorisedLoans.lGroup TO 'cpses_dikfgmbqhy'@'localhost';
FLUSH PRIVILEGES;

2. 修正JOIN关联条件 #

原查询的JOIN条件存在逻辑错误：GroupMemberQ.AccountNum = AuthorisedLoans.lGroup中，AuthorisedLoans.lGroup是表名而非字段，无法与AccountNum关联。需替换为两张表实际的关联字段（假设关联字段为AccountNum，请根据实际表结构调整）：

SELECT
    AccountNum,
    GroupName,
    mFName,
    mSName,
    FacilityID,
    lGroup,
    LRate,
    PrincipleAmount,
    Interest,
    TotalLoan,
    Installment,
    PeriodOfFacility,
    FstInstallmentDate,
    FinalInstallmentDate,
    fUser
FROM
    GroupMemberQ
JOIN AuthorisedLoans.lGroup 
    ON GroupMemberQ.AccountNum = AuthorisedLoans.lGroup.AccountNum;

内容的提问来源于stack exchange，提问作者Golden Nyirenda