Re: SQL Inserting from one table to another with different column names -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: SQL Inserting from one table to another with different column names
From: nicolas <nfaucheux@xxxxxxxxxxx>
Date: Wed, 01 Apr 2009 15:21:16 +0200
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hi,

(c4 goes to c1 AND c2 ?)

when executing insert..select, sql doesn't check the names, but the types

insert into t1
select c4, c4, '' from t2

David FOXWELL a écrit :

Hi,

IF I have table T1 with columns C1, C2, C3, and T2 with columns C4 and C5.

How do finish my sql statement :

Insert into T1
Select from T2

I want C4 to go to C1 and C4 to C2 with C3 blank.

Thanks

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.