MySql连表查询(两种写法)

写法一：

SELECT
    *
FROM
    cast_schedule AS a
INNER JOIN open_cast_course AS b ON a.cast_course_id = b.id
WHERE
    b.check_status = 1;

 

写法二：

SELECT
    *
FROM
    cast_schedule AS a,
    open_cast_course AS b
WHERE
    a.cast_course_id = b.id
AND b.check_status = 1;