Problem with query

[Claus Mygind]

I cannot get the following to work, it should return 2 rows but I get 0.

Select c.`WillAttend`, c.`Responded`, m.`Company`, c.`Last`, c.`First`
from contacts c
left join company m on m.id=c.id
where c.`Responded` = "T" and c.`WillAttend` = '20090101' and m.`name` like "O%"
 

However if I do one or the other like this it works fine

Select c.`WillAttend`, c.`Responded`, m.`Company`, c.`Last`, c.`First`
from contacts c
left join company m on m.id=c.id
where c.`Responded` = "T" and c.`WillAttend` = '20090101' 
 
or
 
Select c.`WillAttend`, c.`Responded`, m.`Company`, c.`Last`, c.`First`
from contacts c
left join company m on m.id=c.id
where  m.`name` like "O%"
 

What's the answer?

[Claus Mygind]

Never mind. I was selecting on the wrong field m.name should have been m.id

[numberwhun]

@Claus Mygind
Nice job finding it on your own. Sometimes it takes taking a step back. I was going to point that one out.

Regards,

Jeff