-=> Quoting Kai Strang to Bill Cheek <=-
 BC> I'm suffering from a case of massive brain flatulence and can't for the 
 BC> life of me, figure out the following dilemma for an ACCESS 95 situation:
 BC> Given the following two tables where Table 1 is a list of fruits grown 
 BC> in a certain county and Table 2 is a list of growers in that county and 
 BC> their crops:
 KS> SELECT DISTINCTROW Table1.Crop, Table2.Grower
 KS> FROM Table1, Table2
 KS> WHERE (((Table1.Crop)=[Crop1])) OR (((Table1.Crop)=[Crop2])) OR
 KS> (((Table1.Crop)=[Crop3])) OR (((Table1.Crop)=[Crop4])) OR
 KS> (((Table1.Crop)=[Crop5])) ORDER BY Table1.Crop;
Trouble is, what happens when a grower has more than 5 crops.  What if he
has 20 or 40.  Unlikely, yes.  Impossible, no.
Thus I feel the problem should be solved by splitting the table into two.
Tony
--- Blue Wave/Max v2.12 [NR]
---------------