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 |
|
jspaeth
Starting Member
1 Post |
 Posted - 2008-08-04 : 10:32:17
|
| I have 4 tables that all have an OrderNum field in common. Having both detail tables in a query returns an inflated record set. The tables are:ShipmentHdrShipmentDetailOrderHdrOrderDetailThe problem is having both detail tables included in a query while linking on the orderNum. These tables contain multiple duplicate orderNum entries since an order and a shipment can have multiple detail lines OrderNum entries. I need to pull info from both detail tables. Do I need to create a reference table?ANY help would be appreciated.Thanks |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-08-05 : 08:50:44
|
| Some table struture, sample data & expected output would help a lot here. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Design Problem: inflated records returned