I've created a left join query that doesn't display all the records in the query ... it must be due to I have criteria on the other table. It does not display student records that don't have a scholarship awarded in the 'right' trable. Here is the SQL:
I found I can use the following SQL to display all the records I want but can't update values .... I'd like to change scholarship amounts for a student.
Here is that SQL:
Any advice is appreciated.