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 |
|
slihp
Yak Posting Veteran
61 Posts |
 Posted - 2009-02-17 : 11:22:10
|
Hi all;I have the folowing query and result set. i would like to get combin the results into one line. is this possible without using sub querys in my select statment. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-17 : 11:22:36
|
| where's the query? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-17 : 11:27:08
|
Either use UNION or UNION ALL or FULL JOIN or INNER JOIN.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2009-02-17 : 11:36:42
|
| Sorry image didnt go up first time. So i would have one line that would read194439 | 79844 | 66521.92 | 69595.38 |
|
|
|
degraft
Starting Member
10 Posts |
Posted - 2009-02-17 : 11:39:52
|
| Can't see the query. Try post it again.DD |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Group By Issue