mysql多表查询等值连接、为表取别名

#案例：查询女神名和对应的男神名

SELECT 
    NAME,boyName
FROM
    boys,beauty
WHERE
    beauty.boyfriend_id=boys.id;

USE myemployees;SELECT 
    NAME,boyName
FROM