sql - 将 SQL 服务器查询转换为 SQLite

Question

我有以下 SQL 服务器查询，我想将其转换为 SQLite 查询

我主要与别名左外连接作斗争。任何帮助深表感谢

SELECT t.col1, isnull(b.term_date, t.term_date) as term_date,
  FROM table1 t
  LEFT OUTER JOIN(
       SELECT form_num, max(avg_term_date) term_date
       FROM table2
       GROUP BY form_num
    ) b on b.form_num = t.form_num;

标签： sqlsql-serversqlite

Answer 1

使用正确的查询，coalesce()它看起来像标准 SQL：

select t.col1,
       coalesce(b.term_date, t.term_date) as term_date
from table1 t left outer join
     (select form_num, max(avg_term_date) term_date
      from table2
      group by form_num
     ) b
     on b.form_num = t.form_num;