Re: combining 2 tables
Posted by: Rick James
Date: June 29, 2012 08:18AM

INSERT INTO new (...)
JOIN t2 ON t1.a = t2.a AND t1.b = t2.b AND t1.c = t2.c

This assumes the tables t1 and t2 are fully in a 1:1 relationship on those 3 columns (a,b,c). If not, you may need LEFT JOIN or some other technique.

Options: ReplyQuote

Written By
June 26, 2012 06:38PM
Re: combining 2 tables
June 29, 2012 08:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.