Does the Connector support UNION Queries for Sage 100 Data?
Have a simple UNION that just doesn't seem to work. See sample below:
Select
JT_Transaction.SalesOrderNo as 'SalesOrderNo',
JT_Transaction.TotalCost+JT_Transaction.TotalLaborCost+JT_Transaction.TransactionAmt as 'TotalCost',
(JT_Transaction.ParentCostRecognized+JT_Transaction.NonChrgLDDCCosts)*-1 as 'InvoicedCost',
JT_Transaction.TransactionDate as 'TransactionDate'
From JT_Transaction
UNION
Select
JT_TransactionHistory.SalesOrderNo as 'SalesOrderNo',
JT_TransactionHistory.TotalCost+JT_TransactionHistory.TotalLaborCost+JT_TransactionHistory.TransactionAmt as 'TotalCost',
(JT_TransactionHistory.ParentCostRecognized+JT_TransactionHistory.NonChrgLDDCCosts)*-1 as 'InvoicedCost',
JT_TransactionHistory.TransactionDate as 'TransactionDate'
From JT_TransactionHistory