[AccessD] SQL INSERT Question

Michael R Mattys mmattys at rochester.rr.com
Wed Jan 23 18:31:36 CST 2008


Hi Susan,

Uh, well ... I was wrong ... just one rs
Anyway ... enjoy your evening :)

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, January 23, 2008 7:21 PM
Subject: Re: [AccessD] SQL INSERT Question


> 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.
>
>
>> http://www.w3schools.com/sql/sql_insert.asp
>>
>> Since the values were coming from 2 recordsets,
>> the VALUES statement made sense given the
>> lack of FROM <TABLE> in the SQL string.
>>
>> As the saying goes, "There's more than one way to skin a cat"
>>
>> Michael R. Mattys
>> MapPoint & Access Dev
>> www.mattysconsulting.com




More information about the AccessD mailing list