[求教]复杂查询时，Active Record 类的用法
请教如下的sql，用Active Record应该怎么写？SELECT sc.*, si.ExtendCode AS ExtendCode2
FROM (SELECT * FROM table1
WHERE (OwnerID = '143') AND (isDraft = 0)) AS sc LEFT OUTER JOIN
(SELECT DISTINCT ExtendCode FROM table2) AS si
ON sc.ExtendCode = si.ExtendCode
ORDER BY sc.LastUpdate DESC
这么复杂的 SQL 用 AR 没必要吧，恐怕 AR 做不到。
Active Record 和 SQL 不是一一对应的，复杂 SQL AR 做不出来。
页:
[1]