Tables "table1 & table2" have one-to-one relationship. Consider outer joining.

The cardinality relationship between these tables seem to indicate that they could be JOINed in the script. This would reduce the number of table hops and may improve overall performance.