Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL question
I have a problem "joining" two tables.
One table contains data like S_ID, name, notes, created_date.
A second table S_ID, property_ID, property_value
For property_ID values from 1 to 10 are possible the meaning of the
property_idis stored in a separate table (property_id, name).
I would like to create an output in the form:
S_ID, name, notes, created_date, property_id=1, property_id=2
I don't need a dynamic table, the table should consist of fields from
table1 plus two properties.
Can this be done with a single sql statement without first retrieving
the records from table1 and then looping through this table to get the
properties from table2?
Received on Thu Apr 20 2006 - 02:46:50 CDT
![]() |
![]() |