Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> SQL: views and joins
Hello,
Could someone spare a minute or two to help me out?
If I have two tables like this (ID and DATA are strings)
TABLE A
ID_A
DATA_A
TABLE B
ID_B
DATA_B
with the data
TABLE A
ID_A DATA_A
'123' 'a-data'
and
TABLE B
ID_B DATA_B
'123' 'b-data'
'124' 'b-data2'
how should I create a view that would collect this data like this:
VIEW V
ID DATA_A DATA_BReceived on Mon Jun 04 2001 - 04:48:49 CDT
'123' 'a-data' 'b-data'
'123' null 'b-data2'
![]() |
![]() |