7 Replies Latest reply on Oct 5, 2016 9:26 AM by David Li

    Fetch Customer Orders for Customer who have placed orders just today and not in the past

    Udit Mahajan

      I have two tables

      a. Customers ( CustomerID)

      b. Cases (CustomerID, CaseID, Datein).

       

      I want to fetch only those customers who have placed orders just today and never in the past(basically new customers)

      In the cases table, an entry gets created only when a customer has placed an order.

       

      I am struggling to write a custom SQL query and to fetch the result in Tableau.

       

      Regards,

      Udit