Path: utzoo!attcan!uunet!cs.utexas.edu!samsung!brutus.cs.uiuc.edu!apple!uokmax!occrsh!att!chinet!les From: les@chinet.chi.il.us (Leslie Mikesell) Newsgroups: comp.databases Subject: question: grouping dissimilar items Message-ID: <1989Nov21.175241.19529@chinet.chi.il.us> Date: 21 Nov 89 17:52:41 GMT Reply-To: les@chinet.chi.il.us (Leslie Mikesell) Distribution: na Organization: Chinet - Chicago Public Access UNIX Lines: 4 I need to take a list of contestants from various states, a list of judges/moderators from various states, and produce groups of 4 contestants, 1 judge, and 1 moderator all from different states. Can someone suggest a way to do something like this in a database routine?