Is it possible to do a query over more than one server?
Working with joins works like a charm, working with aliases is also no issue but it looks like working with more than one server is not possible or do I mistake here?
var query = "SELECT I.invoicesid FROM invoices I, organization O WHERE I.invoicedate>='" + utils.dateFormat(globals.newDateTime, "yyyy-MM-dd 00:00:00.000") + "' AND I.invoicedate<='" + utils.dateFormat(globals.dueDateTime, "yyyy-MM-dd 23:59:59.999") +"' AND O.accountmanager='" + globals.Accountmanager + "' AND I.organizationid=O.organizationid AND (I.status=2 OR I.status=4)"
Users browsing this forum: Google [Bot] and 26 guests