SQL Query Problem

Question

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

Smart Lucky · Answer

Thanks for helping dear still duplicate data showing because distinct work on row if row has same data then it will skip it Thanks

Ramesh Maruthi · Answer

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