Re: not registed for a course and who has paid the most registration

[Paul Smith]

For a)
I need to be able to obtain the name of any customer who has not registered for a course

select name from tblCustomer
where (select confirmed from tblcourses is 0 or null);


for b)
I need to be able to obtain the name and registration paid of the customer(s) who have paid the most registration

select tblcustomer.name, tblCourseRegistration.CRegistrationPaid from tblCustomer,tblCourseRegistration
where (select sum(CRegistrationPaid) from tblCourseRegistration)


thanks for your help