Re: Update table 1 with data from Table 2?

macromedia.coldfusion.database_access

Re: Update table 1 with data from Table 2?

Subject:	Re: Update table 1 with data from Table 2?
From:	"paross1" <webforumsuser@xxxxxxxxxxxxxx>
Date:	Tue, 29 Jul 2008 15:21:13 +0000 (UTC)
Newsgroups:	macromedia.coldfusion.database_access


How about something like this?

 UPDATE newtable n
 INNER JOIN oldtable o ON o.PhysicalLocationID = n.old_location_ID
 SET n.vendor_address1 = o.Street1,
 n.vendor_address2 = o.Street2,
 n.vendor_city = o.City,
 n.vendor_state = o.StateID,
 n.vendor_zip = o.Zip,
 n.vendor_zip4 = o.Zip4,
 n.vendor_tele = o.Phone,
 n.vendor_fax = o.Fax

 Phil

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
Update table 1 with data from Table 2?, newportri Re: Update table 1 with data from Table 2?, Dan Bracuk Re: Update table 1 with data from Table 2?, newportri Re: Update table 1 with data from Table 2?, Dan Bracuk Re: Update table 1 with data from Table 2?, musicmp3 Re: Update table 1 with data from Table 2?, paross1 Re: Update table 1 with data from Table 2?, newportri Re: Update table 1 with data from Table 2?, paross1 <= Re: Update table 1 with data from Table 2?, newportri

Previous by Date:	Re: Creat new table from multiple tables in same DB?, newportri
Next by Date:	Re: Creat new table from multiple tables in same DB?, newportri
Previous by Thread:	Re: Update table 1 with data from Table 2?, newportri
Next by Thread:	Re: Update table 1 with data from Table 2?, newportri
Indexes:	[Date] [Thread] [Top] [All Lists]