title: Get Records By Most Recent Date From two tables
body: <p>I have two SQL tables. Each has an ID with other columns and a Date.</p>
  
  <p>Is there a way that I can get the result from these two tables in one query sorted by the date? For example, as a result, I may have one record from table 1 followed by two records from table 2 and then another record from table one and so on. I have tried the code below but I think that I am not on the right track.</p>
  
  <p>I would appreciate your help.</p>
  
  <pre><code>SELECT
      app.ID as 'AppraisalID',
      app.CityName,
      app.CountryName,
      app.Street,
      app.DateCreated,
      subApp.ID as 'SubAppraisalID',
      subApp.Message,
      subApp.DateCreated
  From
  (
      SELECT TOP 10
          dbo.Appraisal.ID,
          dbo.Appraisal.Street,
          dbo.Country.Name as 'CountryName',
          dbo.City.Name as 'CityName',
          dbo.Appraisal.DateCreated
      FROM dbo.Appraisal
      INNER JOIN dbo.Country ON dbo.Appraisal.CountryID = dbo.Country.ID
      INNER JOIN dbo.City ON dbo.Appraisal.CityID = dbo.City.ID
      Order by dbo.Appraisal.DateCreated DESC
  ) app
  Cross Join
  (
      SELECT TOP 10
          dbo.Sub_Appraisal.ID,
          dbo.Sub_Appraisal.Message,
          dbo.Sub_Appraisal.DateCreated
      FROM dbo.Sub_Appraisal
      Order by dbo.Sub_Appraisal.DateCreated DESC
  ) subApp
  Order By
      app.DateCreated DESC,
      subApp.DateCreated DESC
  </code></pre>
  
  <p>Thanks guys.</p>