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 |
|
banderbe
Starting Member
2 Posts |
 Posted - 2009-04-07 : 14:05:36
|
| Let me phrase my question in a generic fashion:Let’s say there’s TableA with three fields Field1, Field2, Field3 and those fields are all constrained by FieldID in TableB. TableB also has a field called FieldName.I just want get all the fields in TableA but instead of the integers in Field1,2 and 3 get the FieldName the integers correspond to.I'm a SQL noob so I don't know the best way to do this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
banderbe
Starting Member
2 Posts |
Posted - 2009-04-07 : 20:58:02
|
| I assume you meantSELECT t1.Column1, t1.Column2, t1.Column3 ?? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Foreign Key look up