RE: SQL Query

[Jeremy Ridout]

Title: SQL Query

Do you have CF 5? Query of Queries would do this quite easily.

 

Query the first database. Then make a second query, dbtype=query, and query against the first query where tableA.PK = tableB.FK.

 

Jeremy

-----Original Message-----
From: David Hagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:50 AM
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Query

I need to get the primary key from table A in database Employee and find all related info on table B in database Personnel.  Will Union do that and if so what is the syntax to use two different databases in one query?

-----Original Message-----
From: Eli Sanders [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:54 AM
To: [EMAIL PROTECTED]
Subject: RE: SQL Query

Try using UNION

-----Original Message-----
From: David Hagen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:40 AM
To: [EMAIL PROTECTED]
Subject: SQL Query

I need help constructing a query that pulls information from a table in one database from a table in another database. ( from two different datasources).  The database is SQL Server 2000.  Thanks!

Dave Hagen
Technology Director
NexGen Solutions, Inc.
209 E. 6th Street
Austin, Texas 78701
work:    512-583-4844
cell:    512-784-4425
pager:   877-502-0173