Community Hub
Community Support
Site Help
Cancel
Search
User
Site
Search
User
Browse By Tags
All tags
Sage ERP
MAS200
query
Linked Server
providex
SQL
Complex Query
Vikram
Hello, I am new to the world of Sage ERP. I have designed this query and it works fine in SQL: SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…
over 9 years ago
Sage 100
Customization and Productivity