![]() |
Alexey admin 5/4/2007 |
Hi, select `InvoiceID` , _WorkOrder.CustomerName, _WorkOrder.Hours, _WorkOrder.Rate, _WorkOrder.Material, _WorkOrder.WorkDone, _WorkOrder.Rate_WorkOrder.Hours + _WorkOrder.Material + _WorkOrder.Material0.05 as InvoiceTotal From `_Invoice` inner join _WorkOrder on _Invoice.WOID=_Invoice.WOID |