I have a sql challenge for those of you who wish to accept it. I am trying to write a query on two tables, with a many to one relationship. Let us call the primary table A, and the foreign key table B. For each record in table A, I would like 1 (and only 1) corisponding record from table B. The 1 record should be the result of the top record from a sort on table B. The use of cursors will be considered cheating. I think this is possible, but I am open to someone proving it is not as well. Good luck. Ben Liyanage ben at smartankgroup.com 410.336.2464