Member Avatar for jtreyes

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?

  • 3 Contributors
  • 2 Replies
  • 73 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for nav33n

It would be easier for us if you give us the structure of the tables and also the query that you are using.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.