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.

P.S. Please let me know if this is in the wrong group.

"Feek" wrote:

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 (AT) discussions (DOT) microsoft.com> wrote