Am 17 Nov 96  12:01:08 schrieb Tony Toews an Kai Strang zum Thema 

Hi Tony,
> situation:  Given the following two tables where Table 1 is a list 
BC> of fruits grown  in a certain county and Table 2 is a list of 
BC> growers in that county and  their crops:
TT> 
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;
TT> 
TT> Trouble is, what happens when a grower has more than 5 crops.  What if he
TT> has 20 or 40.  Unlikely, yes.  Impossible, no.
TT> 
TT> Thus I feel the problem should be solved by splitting the table into two.
TT> 
TT> Tony
You are absolutely right about this, but I was merely trying to give Bill a 
solution on the problem, because I understood he had to make do with those 
two tables and their respective structures.
If he is able (allowed) change the structures, your solution is to be 
preferred by all means :-)
  Kai
Bis dannemann
  HacMac
--- FIPS/32 v0.97 W95/NT [M]
---------------