I execute the following query as advised and results was:

EventID EventDate EventDate

1 ...

Peso perfect. It worked great. Next time I'll provide more detail. Thanks.

18 columns to be exact. I need a total for each row with a vale of "1" from there I can get the value of "2" or "3" by changing...

Matt,

You are correct again. The event.courseID=T1.courseID works like a charm. Thank you again for all your help.

Matt / GSquared

BINGO. 😀

I used event.courseID instead of t2.courseID as you instructed and also changed (Event.CourseID=t2.CourseID) to Event.CourseId=Event.CourseID)

The results:

The golferId, courseId, Hole1 diff, Hole2 diff, and Hole3 diff.

Perfect. Thanks for...

Tried it and got Invalid column name 'CourseID'.

Maybe I need to redo my tables. Do you think?

The first statement has the error:

(select courseID from ScoreCard) receives an error of Invalid column Name 'courseID'.

The second statement gives me the courseID value.

Sure.

SELECT GolferID, t2.CourseID

, t2.Hole1 - t1.Hole1

, t2.Hole2 - t1.Hole2

, t2.Hole3 - t1.Hole3

FROM ScoreCard t2

JOIN CoursePar t1 ON (t1.CourseID=t2.CourseID)

Made the correction. Now I get:

Msg 207, Level 16, State 1, Line 6

Invalid column name 'CourseID'.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'CourseID'.

rbarryyoung thank you for your help.

I copied the query statement and received the following error message.

An expression of non-boolean type specified in a context where a condition is expected, near...

Here is what I'm trying to accomplish.

I'm creating a golf scorecard. The golf course has pars on each hole and I would like to calculate the difference against a players...

Thank you for your reply. I've tried the EXCEPT and it only returns the value that was on table1. I need it to calculate the difference.

If column1 has a value...