How to get Log table data first using two SQL Table : I need sql query to  get Log table data first using two SQL Table, actual why i am using log table because when user will update his file then it will stored in Table_AttachLog but i kind use inner join between two table because that it log table. I know using updateddate column order by desc, we can get but how to use both of table.

Table_AttachLog

    RegistrationID     uploaded File             updateddate
     101                myprofile.doc             2018-03-25 00:45:08.500



Table_Registration     

    RegistrationID     Name      Email                 uploaded File         submitted
    100                Rohan      rohan@gmail.com      rohanfile.doc       2018-01-12 00:45:08.500
    101                mazhar   mazhar@gmail.com       myprofile.doc       2018-03-13 00:45:08.500
    102                raj      raj@gmail.com            raj.doc           2018-01-16 00:45:08.500



I need query that  updateddate of Table_AttachLog should come first order by desc follow below output


    RegistrationID     Name      Email                 uploaded File         submitted
     101                mazhar   mazhar@gmail.com       myprofile.doc       2018-03-13 00:45:08.500
     100                Rohan      rohan@gmail.com      rohanfile.doc       2018-01-12 00:45:08.500
     102                raj      raj@gmail.com            raj.doc           2018-01-16 00:45:08.500
