If you have values in one table that do not have corresponding data in the
second table you will probably have to use a LEFT JOIN with Classes being
the table on the left of the join operation, this will return all classes
irrespective of whether there are null values in the table on the right of
the join operation. This may be your problem if you are not getting an error
(CF error that is)
HTH
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
"Nitendo Vinces - By Striving You Shall Conquer"
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
