Re: How does SELECT work?

On Mon, 8 Jul 2002, Konrad Den Ende wrote:

> Say that we have two tables COFFEES and SUPPLIERS
> (yes, from Suns site). When i execute this:
>
> "Select * COFFEES, SUPPLIERS"
>
> and print the results (only one column - Cof_Name) i get
> all the names of coffees (which i expected) BUT three
> times!
>
> As there are three rows in SUPPLIERS i start to suspect
> that the command above gives me result of EVERY row in
> table 1 FOR EVERY row in table 2.

Exactly.

> The question: Have i done something stupid or is my suspicion
> correct?

Why don' you use some conditions after the keyword "WHERE" ?

 Raffaello Received on Mon Jul 08 2002 - 09:59:41 CDT