i would like to create a query using providex sql which gives me the current year to date and prior year dollars sold total for each customer. my query currently has the AR_CustomerSalesHistory table left -joined twice to the AR_Customer table; one instance…
