Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL: views and joins

SQL: views and joins

From: Nicklas Karlsson <nicklas.karlsson_at_ineo>
Date: Mon, 04 Jun 2001 09:48:49 GMT
Message-ID: <5QIS6.97$3%.10788@read2.inet.fi>

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_B

'123' 'a-data' 'b-data'
'123' null 'b-data2'
Received on Mon Jun 04 2001 - 04:48:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US