Filling in Missing Data

  • Thread starter Thread starter Richard Pinney
  • Start date Start date
R

Richard Pinney

I have a query that shows all the base discounts for a product and another
query that shows a list of special discounts for a customers. What I am
trying to do is show all the discounts that the customer gets and if there
are any missing discount records for that customer I would like to show them
what the basic discount is as well. I can get it to show the product codes
from the basic discount field but the discount field is blank.
 
What is/are the structure of your table(s)?
What is your current SQL statement:?
 
Back
Top