Flattening a property table
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have a the following table structure t_entity entity_id connect_date disconnect_date t_entity_info entity_id property_name value Let's say I have the following data in the tables t_entity 1 | 1/1/2005 | 12/1/2005 2 | 1/1/2006 | 12/1/2006 t_entity_info 1 | application | ds3 1 | subapplicaiton | wan 2 | application | voice 2 | subapplicaiton | phone I want the following results with one query (using Oracle) 1 | 1/1/2005 | 12/1/2005 | ds3 | wan 2 | 1/1/2006 | 12/1/2006 | voice | phone Anyone got any ideas? Thanks in advance.
Mike Lasseter