I need some help with a query. Here is an example of what I am looking to do.
Table 1 Table2
ColA ColA ColB ColC
Group1 Group1 01/01/08 Screening
Group2 Group1 02/01/08 Closout
Group3 Group1 03/01/08 Initiation
The first table has unique groups. The second table has many so I guess this is one to many.
The resulting table I need will show each group (ie group1) with max date and its corresponding ColC value.
So It would look like this
ColA ColB ColC
Group1 03/01/08 Initiation
Can anyone help with this? I got as far as being able to detemine the maxdate (colB) but when I try to add ColC I get way too many records.