CODEWITHSUNDEEP
mysql
test
test

Reputation: 301

MySQL Statement Returns the same row twice

I have a select statement with multi joins as following : 

SELECT * 
FROM   supplements 
       LEFT JOIN tutorials 
              ON supplements.id = tutorials.supplement_id 
       LEFT JOIN brands 
              ON supplements.brand_id = brands.id 
WHERE  supplements.id = '75'

When I run it , it return the row with the id 75 twice !

Why is this happening ?

Upvotes: 1

Views: 659

Answers (1)

Vimalnath
Vimalnath

Reputation: 6463

It because your child table tutorials or brands might have got multiple values for supplements.id = 75

Upvotes: 2

Related Questions