Basically, an inner join forces both tables to have the same value in the columns you're using in the join.

Table1

ColomnA

1

2

3

Table2

Column A

1

2

SELECT Table1.ColumnA

FROM Table1

INNER JOIN Table2 ON Table2.ColumnA =...

Watch out ms4446, you may be projecting 12 points ahead o' me this week, but...

mbender (10/28/2010)

---

Ouch!

thanks for your help, this is the SQL Newbies forum correct?

Little background on myself, i'm all self taught and new to actually writing in T-SQL. So if i'm...

You remind him of which one? Steve or Bill? 😀

That's really funny by the way.

ChrisM@home (10/26/2010)

---

mtillman-921105 (10/26/2010)

---

Good, then I'm glad I don't...

Good, then I'm glad I don't have to...

WayneS (10/25/2010)

---

mtillman-921105 (10/25/2010)

---

Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we...

Ray K (10/26/2010)

---

LOVED the Giants score last night!!! Take that, Dallas!!!

And I have two Giants on my office fantasy team! Those points took me over the top!

Wish I...

SequelSurfer (10/20/2010)

---

Denver aren't quite firing on all cylinders so it could be a good match up. I will be letting my wife do lots of shopping for Niner's gear as...

Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned. Making...

Good question, thanks. 🙂

Tom.Thomson (10/21/2010)

---

mtillman-921105 (10/19/2010)

---

Maybe...

kevin.l.williams (10/19/2010)

---

mtillman-921105 (10/19/2010)

---

It's simple tasks like this that I think MS needs to work on. Judging by this question, most of us (yours truly included) can't even get an...

I'm saying this as a developer, but my understanding is that both are...

I'm doing fine in both of my leagues, but I'm surprised at that. For the last two years, my teams have been just sad. I'm not spending a...