Problem with query and resulting data
Posted on 2011-09-30
I have the following issue:
I have a database with the following tables:
- lu_prod_au (luprod_id and luauth_id)
lu_prod_au is the lookup table. Because any product can have up to 4 authors. Every product_id and entered author_id gets stored in this table.
Now when I use the following query this results in a products list where products with multiple authors are displayed multiple times while each product should only be shown once in the list of products.
Note:. The various authors need to get displayed next to the listed product in stead of the repetition of a product with multiple authors stating a different author next to it each time...
Can anyone tell me how to change the query to make it only show each of the products with mulitple authors only once?
Here is the query:
SELECT * FROM products, lu_prod_au, authors WHERE prod_Id = luprod_id AND luauth_id = auth_Id ORDER BY xxx DESC
I hope someone can help me out with this.