SQL：查询多个表，只查看一个表的最新结果，并从另一个表查询所有结果

I have a number of tables and I am trying to pull out data from many of them in one query. I've worked out how to successfully use I have a number of tables and I am trying to pu