SQL Query Not Returning Preffered Results

[elabuwa]

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

[Zane]

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