[AccessD] Quotient join

Jim,

Sounds like the same kind of question Jurgen had in early February. 
Relational Division is the beast.  Look for the thread "Basic Query
Design: Results" and the "Basic Query Design" threads between Feb. 5th
and 10th in the archives.

Steve Erbach
http://TheTownCrank.blogspot.com

On 3/9/06, Hale, Jim <Jim.Hale at fleetpride.com> wrote:
> That's where I found the definition but not the SQL (Edition 1- maybe it is
> described in a later edition?).
> It says this table (SUPPLIER):
> Sname
> Jones Wood Supply
> Orange Coast
> Jones Wood Supply
> Austin Hardwoods
> Orange Coast
> West Lumber
> Jones Wood Supply
> Orange Coast
> West Lumber
> Jones Wood Supply
> Austin Hardwoods
> Orange Coast
> Fred's Woods
>
> divided by this table (TYPE)
> Type
> Mahogany
> Red Oak
> Poplar
> Walnut
>
> equals
> Jones Wood Supply
> Orange Coast
>
> ie all suppliers who supply all types. Kinda neat IMHO
> Jim Hale