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 |
|
curtcormier
Starting Member
2 Posts |
 Posted - 2005-11-30 : 01:46:17
|
| trouble with this...i have a table that looks like this....orderid=1 ordernumber=1 customernumber=1 product=1orderid=2 ordernumber=1 customernumber=1 product=2orderid=3 ordernumber=2 customernumber=2 product=5how can i combine by the actual orderin other words 1 actual order has more then 1 orderid, i need this data more or less in 1 table or query for my form, i think. if you know what im talking about, because i dont think i even do, haha, please helpthanks in advance for your time and understanding with my noob question.Curt |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-11-30 : 01:56:21
|
| pls provide some more information regarding what exactly r u looking for? |
 |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-11-30 : 01:58:54
|
| or try with Group By OrderNumberSurendra |
|
|
|
curtcormier
Starting Member
2 Posts |
Posted - 2005-11-30 : 02:15:32
|
| im trying to get the results to show on a form or report per order number, for instance; my form will show all products order per order number now orderid. thats what im looking for. btw working in access.. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-30 : 04:38:56
|
| we need more information.can you post DDL, (more) sample input data (best in the form of insert statememts)....and most importantly...matching expected results. |
|
|
|
|
|
|
inner join? nested?