Search results

I'm trying to determine the SQL to return only those records in a table which have duplicate values in each of two fields, but different values in a third field. Here's an example: AcctNum FoodType FoodClass ------- -------- --------- A123 Apple Fruit A123 Apple Fruit...

I have a table with the following sample data (the data and field names are fictionalized... I'm not trying to track pieces of fruit!): FruitID Owner Location Type ------- ------ -------- ---- 1 John New York Apple 2 John New York Apple 3 John New York...