Spidey Posted September 24, 2020 Share Posted September 24, 2020 Hi, I have two table: Invoice and Customer. I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug.. ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and date(C.SearchToDate )" ; "" ; "" ) I have an error and couldn't figure it out. Thanks... KC Link to comment Share on other sites More sharing options...
This topic is 987 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now