[AccessD] SQL INSERT Question

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

----- 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 5:04 PM
Subject: Re: [AccessD] SQL INSERT Question


> VALUES is required if the structure of both tables isn't the same.
>
> Susan H.
>
>
>> Isn't it VALUES?
>>
>> And just curious, what is god data?  Shouldn't this post be on OT?
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com