how to join tables sql server
- by Rick
Im having some trouble with joining two tables. This is what my two tables look like:
Table 1
Customer_ID CustomerName Add.
1000 John Smith
1001 Mike Coles
1002 Sam Carter
Table 2
Sensor_ID Location Temp CustIDFK
1000 NY 70
1002 NY 70
1000 ... ...
1001
1001
1002
Desired:
Sensor_ID Location Temp CustIDFK
1000 NY 70 John Smith
1002 NY 70 Sam Carter
1000 ... ... John Smith
1001 Mike Coles
1001
1002
I have made Customer_ID from table 1 my primary key, created custIDFK in table 2 and set that as my foreign key. I am really new to sql server so I am still having trouble with the whole relationship piece of it. My goal is to match one customer_ID with one Sensor_ID. The problem is that the table 2 does not have "unique IDs" since they repeat so I cant set that to my foreign key. I know I will have to do either an inner join or outer join, I just dont know how to link the sensor id with customer one. I was thinking of giving my sensor_ID a unique ID but the data that is being inserted into table 2 is coming from another program. Any suggestions?