本文介绍了将此SQL语句转换为Crystal Reports语言的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想知道如何将此SQL查询转换为公式，因为我需要使用此条件进行过滤并且我很难过这样做。
select * from ARInvoiceDetails ARI1 join ARInvoiceDetails ARI2
on ARI1.InvoiceDetailID = ARI2.InvoiceDetailID
其中ARI1.SubmitTo = 1或
（ARI2.SubmitTo = 2且ARI2.VoucherStatus = 1）;
我感谢您的帮助。
谢谢！
Hi,
I would like to know how can i convert this SQL Query into a Formula because i need to filter using this conditionals and i Having a hard time doing this.
select * from ARInvoiceDetails ARI1 join ARInvoiceDetails ARI2
on ARI1.InvoiceDetailID = ARI2.InvoiceDetailID
where ARI1.SubmitTo = 1 or
(ARI2.SubmitTo = 2 and ARI2.VoucherStatus = 1);
I appreciate your help.
Thanks!
推荐答案
这篇关于将此SQL语句转换为Crystal Reports语言的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！