Can I use two databases in one SELECT statement?

[Augie Dawg]

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.

 

[Kevin Spencer]

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]

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

A.D.