I am writing a simple query that shows sales orders and corresponding purchase orders joined on the item number.
The problem I have is the sales order Item number could have multiple Purchase orders for that item number so i have done a LEFT OUTER JOIN on the item number and that works but the sales order lines are being duplicated and it is confusing the data.
So what i get now is.
What i would like is.
Thanks in advance.
asked May 09 '12 at 10:40 AM in Default
What is being asked for in terms of a data query is returning the right answer. What you want to 'see' is a presentation issue.
To blank out the Order, Line and Item columns, you need to get your presentation layer (application code, report writer, whatever it is you are using to present the data to the user) to handle it.
Not saying you couldn't come up with a T-SQL query to do it, just saying it's the wrong place to do it.
answered May 09 '12 at 11:20 AM
Kev Riley ♦♦