> I have a join that's not working:
What is the error message?
Jochem
For the following SQL there is no error, I just don't get any records ...
NOT TRUE, and maybe significant -- I only get the first record in the
classes table on days when that entry exists. !?! (I'm doing an <cfoutput
query=queryname> so I'm really confused.)
SELECT classes.*, classDates.*
FROM classes INNER JOIN classDates ON classes.classID = ""> WHERE classDate=#createodbcdatetime(eventDay)#
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
