Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT Job.Jobid, Job.company, Job.wellname, Job.rig, Job.rignumber, Job.onlocationdatetime, Job.offlocationdatetime, sfrentaldays * sfrentalrate + wfrentaldays * wfrentalrate + rigupcharge + rigdowncharge + numberoftools * toolredresscharge + sfinsurancedays * sfinsurancerate + wfinsurancedays * wfinsurancerate + servicemandays * servicemanrate - creditdays * creditrate + othercharges + SFStandByDays * SFStandByRate + WFStandByDays * WFStandByRate AS 'Total' , SUM(Total) as 'GrandTotal' <---------this is what I tried but it said no "Total" in the field list FROM Job INNER JOIN JobRentalTicket ON Job.Jobid = JobRentalTicket.Jobid WHERE Job.Jobcomplete = 1 AND JobRentalTicket.invictussentinvoicetoagent = 0 AND Job.offlocationdatetime BETWEEN '2012-01-01 00:00:00' AND '2014-12-31 23:59:59' ORDER BY Job.company
|MySQL query to show different levels from a table.||5||39|
|How to place a condition in a filter criteria in t-sql?||12||32|
|Closing all open child forms.||4||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!