Posted by Roy Harvey on 07/11/07 15:51

On Tue, 10 Jul 2007 17:20:57 -0400, Roy Harvey <roy_harvey@snet.net>
wrote:

>SELECT Make, Model
> FROM TheTable as A
> JOIN Numbers as B
> ON N.i BETWEEN 1 AND A.QuantityOrdered

That last line should have tested B.i, not N.i. The column i is the
integer number column of the Numbers table.

Roy Harvey
Beacon Falls, CT

[Back to original message]