Subject Re: [IBO] Update summary in TableA based on records in TableB
Thanks Rob, I have a job where they have been using Excel sheets and they have been producing summaries of other sheets but also calculations within the main summary sheet.

The idea is that this could be a temporary table or temporary dataset maybe even a View

I can use the SQL queries, inner joins, outer joins etc but it's great to get other peoples ideas.