Hi,

I need to filter out records from a query that select items from 6-7 tables (using union all).
All these tables has a field of transaction guid.
I also have a Transactions table with all tran. guids.

The question is what better to do:
Use an INER JOIN 6-7 times on each item table
or
Add "WHERE itemTransactionGuid in (select trnGuid from Transactions)" on each item table


The query is part of a report's SP so performance is important.
Any help will be appriciated.
Thanks!!