mysql - sql语法错误，我想在一个查询中比较两个表数据

我想比较两个表数据，我编写此查询，请帮助我查找该查询中有什么错误的错误。请纠正我在哪里我错了，下面我写我的查询

SELECT
   er.roomcleaning,
   er.carwash,
   er.laundry,
   ee.roomcleaning,
   ee.carwash,
   ee.laundry
FROM
   Employer_Work AS er ,
   EmployeeRegister AS ee
WHERE
   er.roomcleaning=ee.roomcleaning,
   er.carwash=ee.carwash,er.laundry=ee.laundry

SQL查询：文档

SELECT
   er.roomcleaning,
   er.carwash,
   er.laundry,
   ee.roomcleaning,
   ee.carwash,
   ee.laundry
FROM  Employer_Work AS er
    , EmployeeRegister AS ee
WHERE
   er.roomcleaning=ee.roomcleaning,
   er.carwash=ee.carwash,
   er.laundry=ee.laundry
LIMIT 0, 25

MySQL说：文档


  1064-您的SQL语法有误；检查与您的MariaDB服务器版本相对应的手册以使用正确的语法
  在线的'er.carwash = ee.carwash，er.laundry = ee.laundry LIMIT 0，25'附近
  1


请帮助我，我不知道这是怎么回事

最佳答案

SELECT    er.roomcleaning,
        er.carwash,
        er.laundry,
        ee.roomcleaning,
        ee.carwash,
        ee.laundry
FROM    Employer_Work AS er,
        EmployeeRegister AS ee
WHERE   er.roomcleaning=ee.roomcleaning
     AND er.carwash=ee.carwash
     AND er.laundry=ee.laundry