Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to get most recent and oldest from the the joins to a child table RE: How to get most recent and oldest from the the joins to a child table

  • P.S. If you have any situations where a record in @Employee won't also exist at least once in the two other tables, you will want to use LEFT OUTER JOIN there instead of INNER JOIN.


    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura