Hello List,
I want to append column of two different tables in a single column of a view .
data type of tow column of two diffrent tables will be same.
WHAT I WANT TO DO IS:
| Table 1 |
| ID | DESC |
| 1 | A |
| 2 | B |
| 3 | C |
| | |
| | |
| | |
| | |
| |
| Table 2 |
| ID | DESC |
| 1 | D |
| 2 | E |
| 3 | F |
| | |
| |
| |
| View(Table1|| Table 2) |
| ID_view | Desc |
| | |
| 1 | A |
| 2 | B |
| 3 | C |
| 4 | D |
| 5 | E |
| 6 | F |
| | |
Is there any way???
Thanks in advance
Ashish...
