RE: Extrating Data from One Database from Another
From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 01/20/05
- Next message: Nigel Rivett: "RE: Help with Select statement"
- Previous message: Nigel Rivett: "RE: Describing a table structure"
- In reply to: Steve: "Extrating Data from One Database from Another"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 18:01:03 -0800
select *
from database1.dbo.tbl t1
join database2.dbo.tbl t2
on t1,lastname = t2.lastname
"Steve" wrote:
> Hello,
>
> I am new to sql (very new).
> I have two database, let's call it database1 and database2.
> Both database contains last name, first name and address information.
> Database1 has approximatley 12000 records and database2 has approximately
> 2000 records. Here is what I am trying to accomplish. I will like to match
> and extract data from database1 from database2 based on last name.
> Thanks,
>
> Steve,
- Next message: Nigel Rivett: "RE: Help with Select statement"
- Previous message: Nigel Rivett: "RE: Describing a table structure"
- In reply to: Steve: "Extrating Data from One Database from Another"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
