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 |
|
mintaboo
Starting Member
6 Posts |
 Posted - 2001-08-31 : 18:53:52
|
| Hi,I've been racking my brain. I have two tables:customer: custID int name varchar(20)order:orderID intcust_refID intnow i could 'select orderID, name from order inner join customer on custID = cust_refID'and get all the orders with customer info joined to it. i would like however toget the customers and have their orders joined so i don't have duplicate customers in therecordset. perhaps the numbers could be in a CSV or something. i'd prefer not to do it programatically.any ideas? i think i'm missing something monumentously simple...thanksmintEdited by - mintaboo on 08/31/2001 18:55:11 |
|
|
|
|
|
joining tables