Alvin Bruney [MVP]
4/22/2007 8:16:00 PM
hmmm, regular loops would work but that's kinda tedious. If your database
supports it, you should do it by creating a temp table or a sub query. That
would give you the joined dataset. If the dataset does not support it, you
can create a temporary dataset and merge the two datasets into one using
filters. That's a lot of work though.
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley
"Feek" <Feek@discussions.microsoft.com> wrote in message
news:4B856E58-D38F-4863-B761-A03E699B29B1@microsoft.com...
> P.S. Please let me know if this is in the wrong group.
>
> "Feek" wrote:
>
>> I have some tables from a proprietary ODBC source that I read into
>> Datasets.
>> Because of limitations on this source, only a single LEFT JOIN can be
>> used at
>> a time in the SQL to fill the Datasets. What I'd like to do is to take
>> two
>> Datasets created from LEFT JOIN statements, and LEFT JOIN those to make
>> another Dataset that would basically have all the information it would
>> have
>> if I was able to do multiple JOINs.
>>
>> What's the recommended way to do this...just using regular loops is
>> making
>> the program run way too slow. Right now it's at 30 minutes, and I need it
>> under 5.
>>