I’ve written a query for a report which is designed to pull some of information from a system transaction log (transaction_log), while also looking for a Master value from a second table (location_table) – this does not always exist, as sometimes the master_location or location_id fields can be NULL.