Thanks Michelle. I actually learned a lot about nested queries in the process. I knew you could nest but comparing "a" to "b" in the manner you did was completely...
However unless I did something wrong, max(System_Date) is simply throwing back whatever the most recent date is for each day of the week. For example, 2/4/2009...