Hi,
I am trying to create what, on the face of it sounds a simple enough BAQ, but I am struggling with it. I want all orders and quotes between two dates. That is easy enough, but I want each quote or order on a separate line with no duplicates. What I am getting below is where I am at the moment. I included the Quote and order numbers for clarity. What I want is a single column with a quote or order number in it. I hope this makes sense and that someone can give me the answer. Thank you.
Try with 2 queries using Union All.
1st Query for Orders and 2nd for Quote.
2 Likes
Thanks @fakhruddin, I have never attempted a ‘UnionAll’ BAQ, I shall do some reading and have a go. I had a feeling that what I was attempting was never going to work 
1 Like