I have two SQL tables with a one to many relationship. I will join on the common field . What I want to do is to pull the common field from one table and find the First, or top value in a filed from the "many table". Any help would be appreciated. Thanks