Re: Update table 1 with data from Table 2?

Subject:	Re: Update table 1 with data from Table 2?
From:	"Dan Bracuk" <webforumsuser@xxxxxxxxxxxxxx>
Date:	Mon, 28 Jul 2008 18:51:05 +0000 (UTC)
Newsgroups:	macromedia.coldfusion.database_access


this could be db specific, but when I do that sort of thing using redbrick, I 
use this syntax

update t1
set field1 = t2.field1
, etc

from table1 t1 join table2 t2 on something
where etc

<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: Update table 1 with data from Table 2?, newportri
Next by Date:	Re: Ignoring Rows with Empty Fields?, Dan Bracuk
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?, musicmp3
Indexes:	[Date] [Thread] [Top] [All Lists]