• RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far! I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…
  • Query for job costing across three databases

    I would like to construct an SQL query, which dumps to Excel, an analysis of the job costing for a range of jobs across three different organizations. All have virtually identical structures and naming conventions. There is not a ton of data to grab,…