Greetings. I have created 7 queries in one .bqy file to select supervisor (reporting relationship) data. The results of the 1st query (local results) are used to select the 2nd data set, and so on. All 7 queries select the same fields in the same order.
I want to append (union) all 7 queries (locan results) into one result set. When I insert a new query, I do select Append Query from the quert menu. The help is not very helpful.
Many Thanks.
Kyle
I want to append (union) all 7 queries (locan results) into one result set. When I insert a new query, I do select Append Query from the quert menu. The help is not very helpful.
Many Thanks.
Kyle