Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 17 matches
- 21 Jul 2020, 06:27
- Forum: Sage 50 UK version General Help
- Topic: Audit Split and useage through ODBC
- Replies: 12
- Views: 10963
Re: Audit Split and useage through ODBC
The SQL could be valid, if there are alias's, but that is not the norm and there was no mention of an alias having been setup or anything else. Adding aliases just adds a layer of obfuscation when trying to debug so not a good idea. It is not clear what the OP has or has not done in the way of crea...
- 20 Jul 2020, 06:27
- Forum: Sage 50 UK version General Help
- Topic: Audit Split and useage through ODBC
- Replies: 12
- Views: 10963
Re: Audit Split and useage through ODBC
The sql you post is invalid, it does not have full table names and the case should be uppercase. The SQL is actually valid. The table names use an alias and do not need to be in upper case (upper case is just a commonly used convention. Im using ODBC and with inner join but still cannot get parent-...