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 -~----------~----~----~----~------~----~------~--~---