Mysql join gives duplicate rows

mysql join left-join
Deepak picture Deepak · Jun 15, 2011 · Viewed 37.8k times · Source

I have 2 tables and i am using join to get common records from those 2 tables. i have used the following query but my problem is i am getting the records doubled. The query is as follows

SELECT * FROM pos_metrics pm INNER JOIN pos_product_selling pps ON   
pm.p_id=pps.p_id WHERE pm.p_id='0' AND pps.pos_buying_id='0' AND pm.type=1

pos_metrics table:
enter image description here

pos_product_selling table: enter image description here

Output:

enter image description here

EDIT
When I tried to use GROUP BY and DISTINCT together I am not getting duplicates but the value from the second table is repeated. Any other solutions ?

Answer

Jayakrishnan K picture Jayakrishnan K · Nov 12, 2015

Try something like these 

GROUP BY pos_product_selling.metrics

Related questions

LEFT JOIN only first row

I read many threads about getting only the first row of a left join, but, for some reason, this does not work for me. Here is my structure (simplified of course) Feeds id | title | content ---------------------- 1 | Feed 1 | ... Artists artist_id | …

Read More
How to use mysql JOIN without ON condition?

Is it possible to write join query without ON statement? and how do these joins differ LEFT JOIN, RIGHT JOIN works.

Read More
SQL LEFT-JOIN on 2 fields for MySQL

I have a view A and a view B. In A I have a lot of information about some systems, like IP and port which I want to preserve all. In B I have just one information that I want …

Read More