Hi,
We have AX 2012, We have to tables ProjTransPosting and ProjTransBudget. Both of tables contain ProjID and CategoryID fields.
I would like to get a list of ProjID and CategoryID from these two tables with no duplication by creating a new query. (Union and Distinct)
Please advise
Hi Peter,
You can create query1 with QueryType "Union" and add both tables to this query and select only needed fields for both tables in the query. The next step is to create new View1 based on query1 and selected both fields in the view. Now you can create a new query, add View1 and add a group by criteria.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156