Re: help with data transformations with outer join?
This is a discussion on Re: help with data transformations with outer join? within the SQL Server forums, part of the Microsoft SQL Server category; --> Erland Sommarskog wrote: > And with ANSI JOINS (which I would expect to work on Oracle too): > > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 04:15 AM
| ||||
| ||||
 Re: help with data transformations with outer join? Erland Sommarskog wrote: > And with ANSI JOINS (which I would expect to work on Oracle too): > > SELECT t.username as "User Name", > uxf1.val as "Extra Field 1 Value", > uxf2.val as "Extra Field 2 Value", > uxf3.val as "Extra Field 3 Value" > FROM users t > LEFT JOIN u_xf_view uxf1 ON uxf1.user_id = t.user_id AND > uxf1.xf_name = 'Extra Field 1' > LEFT JOIN u_xf_view uxf2 ON uxf2.user_id = t.user_id AND > uxf2.xf_name = 'Extra Field 2' > LEFT JOIN u_xf_view uxf3 ON uxf3.user_id = t.user_id AND > uxf3.xf_name = 'Extra Field 3' > Thank you very much, that is exactly the info I needed! And yes, this LEFT JOIN technique does work in Oracle. thanks again, Preston      |
 |
« Transaction Log Rollback
|
[SQL-DMO]The name 'tdb_grabowy1' was not found in the Databases collection. »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:27 AM.
