[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
>
> ----- 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com