Lets say you have a view which ties two tables together shows duplicates in the columns, NOT the rows. Each row is distinct. Say for example you have three records for John Smith. So a Field in the table NAME holds his name, then a field in the table FAVORITE COLOR shows his favorite color. He entered blue, red,green, all as distinct rows. Well, in the select query <view> you only want his name to show once, but still have his three favorite colors show. SELECT DISTICT wont do it. Can you filter columns this way?