8 Replies Latest reply on Dec 21, 2017 1:50 PM by GIURGIU CARMEN

    How to populate a row field with dates from another table, in cusom SQL query?

    GIURGIU CARMEN

      Hello,

      I have a custom SQL query where i have "Day of Sign in" and its set to show me the last 2 days( today and yesterday) and its stuck at 2 dates from previous month.

      I've recieved a new tabel with the lates days of sign in, and i dont know how to add  them.

      the field names are not the same, and union doesnt work.

        This is the custom query : select * from (select Date,Shop, .....etc  from Database where Shop='Total' Order by Date Desc limit 2)

         The new tabel has this column :

          New Date

      12/14/17

      12/10/17

      12/1/17

      11/27/17

      How to add the days from New Date so it can reveal the lates 2 days eveyday?

       

         Thank you,

       

       

         Carmen.