RE: SQL Query

[Schreck, Tom]

Title: SQL Query

If your query is inside a transaction, you will not be able to query 2 different datasources.  Just FYI.

-----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