No value given for one or more parameters error

**anrichards22** · 12-08-2014, 08:34 AM

My database has 3 tables (among others):
RelapseTimes: Fields include S1,T2,U3,S4,W4,RID
Relapse: Fields include RID,MID
Clinic; Fields include MID,Date

Basically, all I want to do is get all the values in the RelapseTimes table where the date is within the last 12 months (i.e. after the date 'a').
If I include 'date' as a field in RelapseTimes then I have no issue executing the SELECT statement;

Please Login or Register  to view this content.

However, I have split my tables so that I do not store the same data in multiple tables but cannot get my SELECT statement to work.
Date is now only in the Clinic Table.

I am receiving a 'no value given for one or more parameters' error when attempting to execute this code

Please Login or Register  to view this content.

Any suggestions?
Thanks.

**Norie** · 12-08-2014, 08:42 AM

You only have the RelapseTimes table in the FROM clause, but you are referring to that table and 2 other tables, Clinic and Relapse, in the WHERE clause.

Try adding a couple of JOINs, something like this perhaps.

Please Login or Register  to view this content.

**anrichards22** · 12-08-2014, 08:48 AM

I will give it a try.
Thanks Norie

**anrichards22** · 12-08-2014, 09:49 AM

Norie,

I get a syntax error (missing operator) in query expression RelapseTimes.RID = Relapse.RID LEFT JOIN Relapse ON RelapseTimes.MID = Clinic.MID

Any suggestions?