Question

laravel 两表中id关联 我查出第一张表的所有信息 怎么去除和第二张表里id相等的信息

我解决了

Answer 1

select a.*, b.LastLoginDate, b.IP
from Users a left join logininfo b on a.UID = b.ID
where b.LastLoginDate =
(select max(LastLoginDate) from logininfo where ID = b.ID)