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 |
|
Christech82
Starting Member
20 Posts |
 Posted - 2013-04-12 : 16:25:57
|
Blank |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-12 : 16:33:41
|
| You can make it into a subquery - but subquery of what is not clear to me. If you look at this page for example, he uses subqueries in each example for a specific purpose. What is the goal/purpose that you are trying to get at? |
 |
|
|
Christech82
Starting Member
20 Posts |
Posted - 2013-04-12 : 16:38:53
|
quote:
Originally posted by James K
You can make it into a subquery - but subquery of what is not clear to me. If you look at this page for example, he uses subqueries in each example for a specific purpose. What is the goal/purpose that you are trying to get at?
HI James,I want to list all the details together as a sale details for each client! |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-04-12 : 17:03:04
|
| A subquery may be the right answer, but it's, generally, better if you tell us what you are trying to do. That includes providing sample data and expected output. That way we can provide you with tested solutions. And, in this case, possibly a better solution that a subquery.Here are some links to help show you how to ask your question so we can help you better:http://www.sqlservercentral.com/articles/Best+Practices/61537/http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
|
|
|
CHANGE TO SUBQUERY