I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates.
One example is when I make a query on a sales invoice, it displays four rows of results. each row contains a duplicate of the parts and products.
What could be the problem of my query?
