Hi, kinda hard to tell what you want here. First you say MERGE and then talk about UNION. A Merge is not a union, two totally different operations.
On Mon, Oct 13, 2008 at 9:35 PM, JNewMember <[EMAIL PROTECTED]> wrote: > > I want to do a merge over a common column, lets say i have two tables > that reflect fallowing structure. > > Table 1 Table > 2 > Column-A Column-B Column- > A Column-D > --------------- --------------- > ----------------- ---------------- > 0001 233 > 0003 67000 > 0003* 3000 > 0006 5500 > 0002 80 > 0001 45000 > 0003 (not mistake) 5000 > > > So Column-A can have same value twice (not Unique - I know bad design- > This is more of data extraction). Also table 2 has the same Column-A. > > I was thinking to do a union such as > Select Column-A, Column-B from Table1 union select Column-A, Column-D > from table2 > > is this the bast way to do..? > > Thanks, > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
