10 Replies Latest reply on Oct 14, 2013 1:10 PM by Matt Lutton

    find dealers who have not ordered a product

    Blake Bishop

      Given a Product table, a Dealer table and an Order table in the same Sales database, with the Order table storing a ProductId and DealerID for each OrderId, I'd like to extract a set of dealers who have *not* ordered a particular product (for example, all DealerIDs who have not ever ordered ProductId=200). I'm having trouble determining the best way to set up my data source (some left join combo of the three tables? a data blend? another approach?) and then drilling down to the actual results.

       

      Thanks in advance!