Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-09 : 14:42:35
|
| Patrick writes "I have two tables: options and itemoptionsOptions consists of storeid, optiontype, optionid, description.Itemoptions consists of storeid, sku, optiontype, optionid, dependencytype, dependencyid.I'm wondering if it is possible to use 1 query to select description from the options table twice (one would be for the optiontype-optionid description and the other would be for the dependencytype-dependencyid description) so the output would look like the following:storeid | sku | optiontype | optionid | description | dependencytype | dependencyid | description3 | 200819 | AS | 101 | Small | CC | 101 | Blue" |
|
|
|
|
|
Select column twice with different outputs