查询是:
SELECT * FROM startups where id IN (
SELECT startups.id as id
FROM startups startups
INNER JOIN funds ON startups.id=funds.startup_id
INNER JOIN (
SELECT funds.startup_id, MAX(funds.id) as maxid
FROM funds
GROUP BY funds.startup_id
) f ON funds.id = f.maxid
AND funds.startup_id = f.startup_id
where fund_type="Series B")
事情是内部连接已经在laravel中的两个表之间完成,并且在连接时我必须在'IN'之后以Eloquent查询的形式包含sql部分 . 请帮忙 .