duplicate ID's in sql query

1

My friends have an appointment like this:

SELECT v.product_id,nome AS Produto,presentation AS Descricao, 
    presentation    AS Descricao2, name1 AS categoria, 
    description_two AS descricao, price AS preco, 
    quantity AS estoque, width, height, depth, weight, 
    NAME, referenceCode, datapostagem 
FROM Variant v 
    INNER JOIN ProductCategory p ON v.product_id = p.product_id 
    INNER JOIN Product ON Product.id = p.product_id 
    INNER JOIN Category ON Category.id = category_id 
    INNER JOIN Image i ON i.product_id = p.product_id 
    INNER JOIN DescriptionGroup D ON D.product_id = p.product_id 
    INNER JOIN Stock S ON S.variant_id = v.id 
    INNER JOIN DimensionGroup G ON G.variant_id = v.id 
LIMIT   10

and in this query I return many duplicate product_id how can I create a SUM or to separate the duplicates in another table?

    
asked by anonymous 13.12.2017 / 23:53

0 answers