How does SELECT work?

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.

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

--

Vänligen
Konrad
-------------------------------------------------------
URL: http://konrads.webbsida.com
E-Mail: konrad_at_voxway.com
Phone: (+46) 0708 - 70 73 92
ICQ: 132 250 451