Table Joins

[scabral79]

Hi,

If i have the following 2 tables in a database:

Table 1
Cust_ID Contract_ID Facility_ID
10 1 4
10 2 40
10 3 150
10 4 150
10 5 150

Table 2
Cust_ID Facility_ID
10 4
10 40
10 150


How do i join both table and get only the five rows with the contract_id from Table 1 without duplicates?

 

[LNBruno]

What have you tried so far?

< M!ke >
[small]"Oops" is never a good thing.[/small]

 

[SQLSister]

look up left join in BOL

"NOTHING is more important in a database than integrity." ESquared

 

[bborissov]

Why?
You have all information in Table 1?
Unless you didn't tell us something else


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP