Follow via:
RSS
Email Alert
Question
0 Votes
+ -

SQL Server 2005 data mapping query

Hi Friends

I am looking forward to some help on specific data mapping query in SQL Server 2005. I have two tables having one common column and I want to map a particular column using this common column. This is something similar to INDEX - MATCH function in MS Excel if you have used it. Please advice about the code for the same. Treat this as very urgent as I have to deliver a code to one of my clients in shot time. Thanks.

Kushal
Tags: programming, sql
15th Jul 2007

Answers (3)

0 Votes
+ -
'join'
.
15th Jul 2007
0 Votes
+ -
join
select * from table1 c1 join table2 c2 on c1.commoncolumn = c2.commoncolumn
17th Jul 2007
0 Votes
+ -
Erwin Data Modeling videos needed
hi my name is narasimhareddy i was currently working on data modeling so i need you r help guys.
1st Apr 2011
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.