elabuwa Posted November 17, 2011 Share Posted November 17, 2011 Hello guys, Can some one shed some light on why the below query is returning the wrong results. :'( :'( SELECT campaign_details.pid,campaign_summary.uid,campaign_summary.customer_id FROM campaign_summary,campaign_details WHERE campaign_summary.camp_id=campaign_details.camp_id AND campaign_summary.uid='1' OR campaign_summary.uid='11' AND [b]campaign_summary.customer_id='205'[/b] AND [b]campaign_details.pid='7'[/b] GROUP BY campaign_details.pid I am explicitly telling stupid sql to return only where the campaign_details.pid matches with 7 and campaign_summary.customer_id matches with 205. But I get the below result set. pid----uid---customer_id 1------1-----65 2------1-----84 4------1-----81 5------1-----63 7------1-----65 13-----1-----63 Why is it returning PID's other than 7? Why is it returning customer_id's other than 205? There should be no results at all. Can someone please shed some light? Mysql server v5.0.51 Any help is greatly appreciated Link to comment https://forums.phpfreaks.com/topic/251285-sql-query-not-returning-preffered-results/ Share on other sites More sharing options...
Zane Posted November 17, 2011 Share Posted November 17, 2011 Parenthesis.. and... numbers are not strings.. so no need for quotes. SELECT campaign_details.pid,campaign_summary.uid,campaign_summary.customer_id FROM campaign_summary,campaign_details WHERE (campaign_summary.camp_id=campaign_details.camp_id) AND ( campaign_summary.uid=1 OR campaign_summary.uid=11 OR campaign_summary.customer_id=205 OR campaign_details.pid=7 ) GROUP BY campaign_details.pid1 Link to comment https://forums.phpfreaks.com/topic/251285-sql-query-not-returning-preffered-results/#findComment-1288846 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.