[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.frontpage.programming

Can I use two databases in one SELECT statement?

Augie Dawg

4/17/2004 7:49:00 PM

I need to construct a SELECT statement in which a value found in one
database is used as part of the WHERE clause test to pull out values from
another database. Is there any way to do this within the FP 2002
environment, or am I resigned to writing ASP to get this done?

Thanks,
A.D.
2 Answers

Kevin Spencer

4/19/2004 12:16:00 PM

0

It all depends on what database product you're using. SQL Server and Oracle,
for example, will allow you to create cross-database queries.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Augie Dawg" <NO_SPAMaugiedawg@earthlink.net> wrote in message
news:_Sfgc.14296$A_4.6119@newsread1.news.pas.earthlink.net...
> I need to construct a SELECT statement in which a value found in one
> database is used as part of the WHERE clause test to pull out values from
> another database. Is there any way to do this within the FP 2002
> environment, or am I resigned to writing ASP to get this done?
>
> Thanks,
> A.D.
>
>
>

Augie Dawg

4/21/2004 5:13:00 PM

0

I'm using MS Access (Jet SQL) though the DRW of FP 2002.

A.D.


"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:uARmcigJEHA.3104@TK2MSFTNGP10.phx.gbl...
> It all depends on what database product you're using. SQL Server and
Oracle,
> for example, will allow you to create cross-database queries.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Big things are made up
> of lots of little things.
>
> "Augie Dawg" <NO_SPAMaugiedawg@earthlink.net> wrote in message
> news:_Sfgc.14296$A_4.6119@newsread1.news.pas.earthlink.net...
> > I need to construct a SELECT statement in which a value found in one
> > database is used as part of the WHERE clause test to pull out values
from
> > another database. Is there any way to do this within the FP 2002
> > environment, or am I resigned to writing ASP to get this done?
> >
> > Thanks,
> > A.D.
> >
> >
> >
>
>