>Hi All -
>
>I am experiencing a bit of brain deadness this morning. I set out to write what I thought would be a rather simple SQL select statement but I just can't seem to get my head around it. Thus my plea for help. There are 2 tables CUSTOMERS and ORDERS. Common field is custID. I want to select all customers and the _date and amount of their most recent order (one record per customer). Can someone help me figure out how to do this?
>
>Thanks
Please take a look at these blogs (even though this is SQL Server, several queries are the same in VFP):
Including an Aggregated Column's Related ValuesIncluding an Aggregated Column's Related Values - Part 2
If it's not broken, fix it until it is.
My Blog