RE: SQL Query

[Sorge, Bruce]

Title: SQL Query

A Union Join would look something like this:   SELECT DISTINCT (Value Expression) FROM (Table Reference) UNION JOIN (Table Reference) ON (Search Condition) USING (Column Name)   -----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