SELECT gv_customer.customer, gv_locations.loc_name, SUM(gv_schedule_item.item_cost) AS Invtot
FROM gv_customer, gv_schedules, gv_schedule_item, gv_requests, gv_locations, gv_labels
WHERE gv_customer.customer_id = gv_requests.customer_id AND
gv_requests.loc_id = gv_locations.loc_id AND
gv_requests.req_id = gv_schedules.req_id AND
gv_schedules.sch_id = gv_schedule_item.sch_id AND
gv_customer.owner_id = gv_labels.owner_id AND
gv_labels.label_id = gv_locations.label_id AND
gv_customer.owner_id = <cfqueryparam value="#session.owner#" cfsqltype="CF_SQL_INTEGER">