Search results

  1. B

    Need help with Distinct Count in subquery

    What I want is to summarize the salestran.[Extended Cost] and salestran.[Extended Price] for each salestran.[SKU Code/Number], Count the number of unique customers, salestran.[Customer Code/Number], per SKU for any transactions equal to or after salestran.[Transaction Date] 11/1/2014. Problem...
  2. B

    LEFT JOIN on a partial match

    So I have read at least a dozen forums on this and all seem to have a solution but it is not working for me... Scenario, I have a table with Part No. and their correlating descriptions. I have a second table with a Product Number and its assosciated Part No. I want to view all of my Part No...
Back
Top Bottom