Ok, I've got the following query, but it's not *quite* producing the right results.
Basically, the main table finance, has 4 entries in, but because one of the entries appears twice inside products_categories, the query returns 5 results, not 4.Code:SELECT products.id, products.name, product_options.reference, categories.url_name AS url1, products.url_name AS url2, product_images.image1, option_prices.price_net, finance.description FROM finance JOIN product_options ON finance.reference = product_options.reference JOIN products ON products.id = product_options.product_id JOIN products_categories ON products.id = products_categories.product_id JOIN categories ON products_categories.category_id = categories.id JOIN product_images ON product_images.product_id = product_options.product_id JOIN option_prices ON option_prices.product_option_id = product_options.id
Is there any way to re-write the query so that it only returns 4 lines?


LinkBack URL
About LinkBacks
Reply With Quote
SCAN.care@HEXUS
