在单个查询中选择主记录及其所有相关的外部详细记录？

I have a table that could have thousands (millions maybe?) of records. It is basically an audit trail table that stores special log entries. It's called "Logs".I have a table that could have thousands (milli