Data Issues Very frustrated

I have various sql, sybase & access databases that i need to report from onto
the 1 table. A number of joins link them all together. As you can only use 1
dataset, what would be the best way to report on my data into the one table.
I have spent weeks trying to work this out. ThanksYou could use a stored procedure or view to do all the joins and then call
the one view or stored procedure from your dataset.
John K.
===
"Tango" wrote:
> I have various sql, sybase & access databases that i need to report from onto
> the 1 table. A number of joins link them all together. As you can only use 1
> dataset, what would be the best way to report on my data into the one table.
> I have spent weeks trying to work this out. Thanks|||Thanks John,
Whats your preference here. Id prefer to only have to research 1 options as
time is limited at this stage. Let me know if you need any more info.
"John K" wrote:
> You could use a stored procedure or view to do all the joins and then call
> the one view or stored procedure from your dataset.
> John K.
> ===> "Tango" wrote:
> > I have various sql, sybase & access databases that i need to report from onto
> > the 1 table. A number of joins link them all together. As you can only use 1
> > dataset, what would be the best way to report on my data into the one table.
> > I have spent weeks trying to work this out. Thanks