kurt-erich.finger_at_arcor.de wrote:
> 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?
If you are having a problem writing the query then post the SQL
you have written so we can look at it. Also include the Oracle
version number.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Apr 20 2006 - 11:21:54 CDT
