How to do an-SQL join AND get the latest date without a sub-select
Here is some discussion on a one to many join that needs the many side to return ONE row – the latest one. Also in this article are many links to the related items. It took about an hour to find solutions without a sub-select. Sub-selects are VERY popular – could this be because they […]