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

Home -> Community -> Usenet -> c.d.o.misc -> SQL question

SQL question

From: <kurt-erich.finger_at_arcor.de>
Date: 20 Apr 2006 00:46:50 -0700
Message-ID: <1145519210.498936.86700@g10g2000cwb.googlegroups.com>


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

Original text of this message

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