Hi.  I'm writing a Stored procedure to return the Customer details and 
their transactions.

I'm using a Outer join to do this.  The problem is that I am returning 
the Customer details (Address, Email etc) on each of the Transaction 
lines.  This is slowing down the whole process.

I'm using .NET for my application, so I was wondering if there was an 
easy way to return the Customer table and the Transaction tables 
seperatly from the same SELECT statement.????

Thanks for your time.  And I'm sorry if this is a stupid question


Matt