Loading

SQL Query Problem

Smart Lucky

12y1.3kSQL

Hi dudes

I have query issues i have company table and a coupon table and relation is one to many means company can has many coupons i want just show in query company name with coupon name just one coupon of each company i did query in this way it is showing duplicate data...

SELECT comp.name,c.name FROM company comp LEFT OUTER JOIN coupon c ON c.companyid= comp.id
GROUP BY comp.name,c.name

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Smart Lucky12y ago
Thanks for helping dear still duplicate data showing because distinct work on row if row has same data then it will skip it Thanks
0
Ramesh Maruthi12y ago
SELECT Distinct comp.name,c.name FROM company comp LEFT OUTER JOIN coupon c ON c.companyid= comp.id
GROUP BY comp.name,c.name
0