I have an interesting SQL situation for everyone.

Here's the situation:

I have an interesting report I have to create. It looks something lie this.

PART TOT PARTS(INHOUSE) TOTAL % TOT PARTS(CUST) TOTAL% TOTAL TOTAL%

1 100 20 150 30 250 100


The totals come from 2 sepearate tables.

Thanks for the input

Perry