I am looking for an example of a INNER JOIN clause using a TOP syntax. Basically, as this is not a one to one relationship, I need to get the TOP most record, based on a condition, of the INNER JOIN table I am using. So, this is simple. I would end up with MIN(Table.PrimaryKey) and then Table.MyField.