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

Reply via email to