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-01-31 : 21:37:02
|
Richard Orchard writes "Hi,
I have a table for addresses - each user can have two addresses therefore they have suburb_id_1 and suburb_id_2 as two different fields that both relate to the same table (suburb_t).
However, you aren't allowed to perform a join to the same table twice to retrieve the value of the suburb name.
I am wondering what would be the best way to handle this.
Thanks in advance,
Regards
Richard" |
|
|
|
|
|
Two