Ways to join and update tables in SQL.

Question

Hi,

So I am a first time user here, and still relatively new to SQL. I am attempting to take 2 tables, and join them in a sense.

In Table1 I have the data:

House_Key ---Other Fields---   Customer_ID

House_Key is not unique, and as such I can have multiple Customer_IDs per household. House_Key is a numerical code, and Customer_ID is either Home, Business, or Bulk.

In Table2 I have the House_Key field, but not the Customer_ID field.

My goal is to have a new table that holds the fields of Table2 with a field called Customer_ID, but instead of having a new row for each type of Customer_ID like in Table 1, I want to have each House_Key only have one row, and the Customer_ID say something like "Home Business Bulk" if it is all three or any combination of them, but would prefer that it always have Home before Business before Bulk in the field.

Is there any way to do this? Thank you very much ahead of time.

Also, not sure if it matters, but in case it does I'm using SQL Server 2005.

Answer 1

Wow, I'm glad that you came here for an answer, but seems that you really need some reading about relational databases.

Instead of writing looong answer here're the links:

http://en.wikipedia.org/wiki/Database_normalization

http://en.wikipedia.org/wiki/Join_(SQL)