草庐IT

enrollments

全部标签

php - Laravel - 从一个表中获取另一个表中不存在的记录并附加 where 子句

我有以下SQL表(在MySQL中):students+-----+------------+|id|first_name|+-----+------------+|01|John|+-----+------------+|02|Jane|+-----+------------+|03|Peter|+-----+------------+academics+-----+-----------+----------+------+|id|year_start|year_end|status|+-----+-----------+----------+------+|10|2016|2017