如何在灵活的Serach查询(Union)中使用Orderby

Question

我试图创建灵活的搜索查询如下：

SELECT uniontable.PK FROM
(
   {{
      SELECT {p1:PK} AS PK FROM {Product AS p1},{Product AS p2} 
      WHERE {p1.code} = {p2.Att1}
   }}
   UNION ALL
   {{
      SELECT {p:PK} AS PK FROM {Product AS p}
      WHERE {p1.Att1} is not empty
   }}
) uniontable

任何人都可以告诉Mehow在上述查询中使用"按"产品关键字的创建时间？

Answer 1

尝试这个，更简单：

 SELECT {p1:PK} AS PK FROM {Product AS p1},{Product AS p2} WHERE {p1.code} = {p2.Att1} AND {p1.Att1} is not empty ORDER BY {p1.creationtime}

希望这有帮助