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 |
|
hle
Starting Member
7 Posts |
 Posted - 2007-10-22 : 09:41:20
|
| I would like to select a row (or multiple rows) from one table and at the same time all related columns from a second table (1:N)example, a phone book; selecting everyone with a certain name from the person_table and all their related phone numbers from the numbers_table, likeSELECT...Smith, John 123456 234567 345678Smith, Will 654321 765432 876543 987654Smith, Eric 55564 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-22 : 09:43:00
|
Using which DBMS?Microsoft SQL Server 2000 or Microsoft SQL Server 2005?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
hle
Starting Member
7 Posts |
Posted - 2007-10-22 : 10:02:52
|
MS SQL Server 2005 Express Edition and (later on) MS SQL Server 2005.quote:
Originally posted by Peso
Using which DBMS?Microsoft SQL Server 2000 or Microsoft SQL Server 2005?
E 12°55'05.25"N 56°04'39.16"
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
result from two tables