Lookup with multiple rowes

[donalexander]

Hello,

I am using SQL Server 2014 I have two tables one is the item master the other customer sales. In the item master I have a column call item and from the customer sales I have the following columns customer, salesitem, salesAmount. The primary table is item master I want to show the all items in the item master regardless if an item is sold I did a lookup, but I am only getting one row of the product only. I want to show the item with possible multiple customer sales. Any help will be appreciated. Thank you.

 

[SkipVought]

Please post a working example of both tables with data that relates, showing multiple customer sales.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein