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 - 2005-04-22 : 08:02:30
|
| David writes "Sorry for the confusing title, but i really don't know how to expaling this simply. Basically i have one table [vehicles] which holds information against a vehicle, and a second table [options] which hold the optional features for a given vehicle. A simple 1-to-many association. What i want to do, is to select the on the first table, but instead of returning muliple row--Select * from [vehicles] ainner join [options] b on a.VID = b.VIDVEHICLE 1 | REGPLATE | OPTION1VEHICLE 1 | REGPLATE | OPTION2VEHICLE 1 | REGPLATE | OPTION3what i would like to return isVEHICLE 1 | REGPLATE | OPTION1,OPTION2,OPTION3i have consided using a while loop, and a cursor. but before i did this i thought i would check to see whether there is abuilt in function or not.thankyou in advance" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Concatinating all rows into a single field 