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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-09-12 : 10:50:16
|
| I working a SQL query that displays open orders and also commissions.Let's say I have 3 tables orderheader, orderline and commRight now I have an inner join that between orderheader and orderlinethat returns 10 records. Only 5 of those records are actually in the comm table. I'm joining the tables on the order number and when I join the comm table I get some duplicate data.I can I only return 10 results with the comm?I would post the query but it's actually 6 mapics tables..I need help with the concept. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 11:12:11
|
maybe you need to use max or min?can you post the DDL, DML, expected results?Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
SQL Join Help