sql - sql查询困难

Question

我有以下表格:

TableA (id, tableB_id, tableC_id)
TableB (id, expirationDate)
TableC (id, expirationDate)

我想从 TableA 中检索按 tableB.expirationDate 和 tableC.expirationDate 排序的所有结果。我该怎么做？

Answer 1

select ta.*
from TableA ta
inner join TableB tb on ta.tableB_id = tb.id
inner join TableC tc on ta.tableC_id = tc.id
order by tb.expirationDate, tc.expirationDate

更新:

如果您没有获得所有记录，那么您将需要使用左外连接:

select ta.*
from TableA ta
left outer join TableB tb on ta.tableB_id = tb.id
left outer join TableC tc on ta.tableC_id = tc.id
order by tb.expirationDate, tc.expirationDate