•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 423,281 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 5,273 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 563 | Replies: 2
 |
•
•
Join Date: Oct 2007
Posts: 13
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
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?
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?
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
It would be easier for us if you give us the structure of the tables and also the query that you are using.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the MySQL Forum
- Previous Thread: General rules for building a database
- Next Thread: Mysql Joins Assistance
