Returns Empty Result Set ??

[prophecym]

Hi everyone,

 

My problem is throwing me off logically.

 

I have a SQL syntax which works for one specific condition of a field but not for others. I can't seem to find the problem. Here is the syntax:

 

SELECT accounttypes.accounttype, contacts.firstname, contacts.lastname, contacts.namesuffix, contacts.emailname, contacts.workphone, speakers.programtrack, participationtypes.participationdescription, speakers.recruitedby, companies.companyname
FROM regcontacts
INNER JOIN accounttypes ON regcontacts.accounttypeid = accounttypes.accounttypeid
INNER JOIN contacts ON regcontacts.contactid = contacts.contactid
INNER JOIN speakers ON regcontacts.registrationid = speakers.registrationid
INNER JOIN companies ON contacts.companyid = companies.companyid
INNER JOIN participationtypes ON regcontacts.participationid = participationtypes.participationid
WHERE regcontacts.participationid= '3'

 

You can see the working code at the end shows regcontacts.participationid= '3'. But if I change it to some other number, it returns empty result set. I am doing something wrong but what I don't know.

[fenway]

Are you certain there are records that have matching results?