 |  |  |  |  |  |  |  |
Problem regarding mysql query: it is displaying duplicate contents
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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?
|
Other Threads in the MySQL Forum
- Previous Thread: General rules for building a database
- Next Thread: Mysql Joins Assistance
| Thread Tools | Search this Thread |
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MySQL
"use" 1 amazon api aws bizspark breathalyzer changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 eliminate email eudora facebook form foss gartner gnu government gpl groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlsearch news opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating query referencedesign remove reorderingcolumns results resultset search select simpledb sourcecode spotify sql statement sugarcrm syntax techsupport thunderbird transparency update virtualization
