[AccessD] SQL INSERT Question

A join without values is equivalent to relational multiplication: the result
set has the number of rows in T1 * the number of rows in T2.

Arthur

On 1/23/08, Susan Harkins <ssharkins at gmail.com> wrote:
>
> I've never tried a JOIN without VALUES, but theoretically, I guess it
> could
> work if all the fields are covered -- but I've never tried. Honestly, I
> missed that they were coming from different recordsets.
>
> Susan H.
>