query help

[teroy]

Hi Guys,
i have the following sql statement

SELECT c.id, c.name, c.username, c.email
FROM customer c, rgheader r, custrate cu
WHERE 0 = 0
AND NOT tech_record = 1
AND cu.custid = c.id
AND cu.rgid = r.id
AND r.id = 200

Now this works okay....but if i want to modify the last line like this

AND (r.id = 200 or r.id = 190)

i get a timeout error. I guess the code i'm trying to produce is inefficient/incorrect. Does anyone have any ideas on how i can rewrite this.

Thanks in advance

 

[teroy]

sorry guys..my bad..i restructured the query and it works fine

SELECT c.id, c.name, c.username, c.email
FROM customer c, rgheader r, custrate cu
WHERE 0 = 0 AND cu.custid = c.id AND cu.rgid = r.id AND
(r.id = 200 OR
r.id = 180) AND (NOT c.tech_record = 1)


Cheers