Re: Access sql question
| From: | Andrian Pervazov | Date: | Tue, 10 Oct 2000 12:55:42 +0000 |
| Subject: | Re: Access sql question | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-3091@lists.php.net to get a copy of this message | ||
It should be "insert into table2 (field1,field2) select
(field1n,field2n) from table1
At least that's how it is on SQL Server
Andrian
alain samoun wrote:
>
> Slightly OT:
> I'm not too familiar with Access db, can I do something like:
> $sql = "insert into table2 (field1,field2) values( select (field1n,field2n)
> from table1)";
> where the corresponding fields have the same type.
> Message from Alain Samoun
> alain@samoun.com
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net