Cancel Request Figured it out by my self

What if the tables were slightly different

Course Details

Course ID

Course Date

Course Bookings

Course Code

client ID

client details

Client ID

Client Details

would it still be the same...

i made the mistake of not putting the display name in on the last bit.

SELECT b.[Client ID],b.[Course Date],b.[Course ID]

FROM [Course Bookings] b

INNER JOIN (SELECT [Client ID],MAX([Course Date]) AS...

sorry to keep bothering you.

Getting an error

"ADO error:  Invalid Column Name 'Course Date'

statement(s) could not be prepared.

deferred prepare could not be completed."

Checked to make sure spelling is correct

Thanks

AB

what about the second select is it coming from table b?

or a new table a?

thanks

yes they can but wont be.

will this work on MS SQL SERVER 2000?

Thanks for the help!!!! Much appreciated

Course Details

Auto number             Course ID    Primary Key

Course Bookings

auto number             course_client_code primary key

long integer              Course Code

date                        Course Date

long integer               client ID

client details

auto number              Client ID    primary key

string                       Client Details

thanks

if you...