Can you create bimodal joins?

From: Bill Kincaid <billkincaid_at_mindspring.com>
Date: Fri, 11 May 2001 07:24:53 -0400
Message-ID: <9dj6kf$crr$1@slb0.atl.mindspring.net>

Am having a problem determining a method of creating a query producing a bimodal join.
Example:

Take a table with 15 temperatures of cities around the world from the CITIES table.

CITIES table

City        A30
Temp      N

New York            12
Atlanta                  57
Philadelphia           25
San Francisco        53
Los Angeles           57
San Diego              55
Mexico City           35
Lima                      35
Quebec                  22
Birmingham            57
London                  40
Portland                 47
Seattle                    49
Chicago                  35
Phoenix                   57

You can see that the bimodal results in 4 examples of 57 and 3 of 35. How do I create a SQL query which will produce this result?

Thanks
Bill Kincaid
BillKincaid_at_mindspring.com Received on Fri May 11 2001 - 06:24:53 CDT