Join two tables on multiple columns?

[rrhandle]

How do I join two tables A and B on A.column1 = B.column1 and A.column2 = B.column2?

 

[SQLDenis]

select * from tableA A
Join TableB B on A.column1 = B.column1 and A.column2 = B.column2

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[DotNetGnat]

SELECT A.*, B.*
FROM table1 A INNER JOIN
table2 B ON
A.col1=B.col1 AND
A.col2=B.col2

and so on...

-DNG

 

[rrhandle]

Thanks to both of you. That is what I tried, but ended up with way more records than I should have had. Now that I know my syntax was right, I know there are columns that don't match. Will have to find those columns. Thanks again.

 

[ispeaker]

That should work.

 

[SQLDenis]

Wow, I replied to this 2 months ago

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ispeaker]

Don't worry, SQLDenis. I, ispeaker, am really rrhandle who for some unknown reason have been unable to login for weeks, and no one will answer my e-mails, so I created a new account, and replied to this post to see what would happen.