`SELECT Transaction.ID, Transaction.TranDate, BUILTIN.DF(Transaction.Type) AS Type, Transaction.TranID, REPLACE(BUILTIN.DF(Transaction.Status), BUILTIN.DF(Transaction.Type) ||' : ', '') AS Status, Transaction.ForeignTotal FROM Transaction WHERE Transaction.ID IN ( -- 这是第一个嵌套 SELECTDISTINCT TransactionLine.Transaction FROM TransactionLine WHERE (TransactionLine.CreatedFrom in ( -- 这是第二个嵌套 SELECTDISTINCT TransactionLine.Transaction FROM TransactionLine WHERE (TransactionLine.CreatedFrom =50878826) ) ) )`
SELECTDISTINCT TransactionLine.Transaction FROM TransactionLine WHERE (TransactionLine.CreatedFrom in ( -- 这是第二个嵌套 SELECTDISTINCT TransactionLine.Transaction FROM TransactionLine WHERE (TransactionLine.CreatedFrom =50878826) ) )
SELECT Transaction.ID, Transaction.TranDate, BUILTIN.DF(Transaction.Type) AS Type, Transaction.TranID, REPLACE(BUILTIN.DF(Transaction.Status), BUILTIN.DF(Transaction.Type) ||' : ', '') AS Status, Transaction.ForeignTotal FROM Transaction WHERE Transaction.ID IN ( -- ... )