There are two tables with same colomns. Is there anyway to get the union result using Generic Inquiry?
Is it possible to UNION two tables in Generic Inquiry?
Hi
You can use Cross 2 DACs in Generic Inquiry but it will create many duplicate lines of data.
Another way you can create a new DAC is by creating a View in SQL and Union 2 tables in SQL.
Best Regards,
NNT
Hi
You can use Cross 2 DACs in Generic Inquiry but it will create many duplicate lines of data.
Another way you can create a new DAC is by creating a View in SQL and Union 2 tables in SQL.
Best Regards,
NNT
Thank You!
I use an attribute called MYPIVOT that is a combo, and I add values 1 to 10 as values with sort orders.
Then I use that in my joins. Add CSAttributeDetail to your inquiry.
The one link to the main table of data has a join of attributeID = ‘MYPIVOT’ and SortOrder is greater than or equal to 2 so it creates 2 lines per main table data row.
Then u join the sub table of data to main but in your join u set the CSAttribututeDetail.sortorder=1.
The second sub table has a join where the sort order =2
And in your inquiry fields you can do formula’s if you only want data on the first row for instance like
=Iif([CSAttributeDetail.SortOrder]=1,[ARTran.Qty],0)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.