8 Replies Latest reply on Jul 17, 2016 1:23 PM by CICT

    Help with an SQL statement


      Hey Guys,


      I have not practiced SQL, pretty much at all, past one or two brief walk throughs, and I'm having difficulty with what I feel is likely a very simple one.


      Goal is to provide a field that gives the total amount of labor on an invoice.


      Invoices have a number of invoice line items. If the item is labor, the record has a 1 in the field "isLabor". Otherwise its blank.


      Here is what I have evolved my attempt into, but still getting the unwelcome "?" in the result.


      ExecuteSQL ( 




      SELECT SUM ExtendedPrice

      FROM INL_Invoices_Line_Items

      WHERE id_invoice = ?

      isLabor = ?


      ;"" ; ID_Invoice ; 1 )



      ####    Table Names:





      Primary Key in Invoices is: ID_Invoice

      foreign Key in INL_Invoice_Line_Items is: id_invoice