Join two tables on two columns

Asked Aug 21 '14 at 06:41

Active Aug 21 '14 at 07:22

Viewed 85 times

I am trying to join an sql table on to another one if two of the rows are the same in both tables.

This is what I came up with:

SELECT a.name1, a.name2, b.score
FROM a
INNER JOIN b
ON a.name1=b.name1
AND a.name2=b.name2

This does not appear to work for me. Obviously I am an sql noob. Any help appreciated.

Sample data:

Table A
123456789_111_000001,123456789_111_000002

Table B
123456789_111_000001,123456789_111_000002,1.023658

Edit: Okay, it's working now. I must have had some syntax error or something the first time. It took 10 minutes to run and didn't return anything. Should I delete the question?

edited Aug 21 '14 at 06:53

asked Aug 21 '14 at 06:41

Mitchell

will [this](http://stackoverflow.com/questions/20396817/join-two-tables-based-on-two-columns) help ? – Romo Daneghyan Aug 21 '14 at 06:43
1

Your query should work, can you provide the data in table a and b? – deterministicFail Aug 21 '14 at 06:46
Please provide sample data. – Siddhartha Gupta Aug 21 '14 at 06:47
Share the sample data along with the expected result.. In principle there is no issue in ur stament. It shld give the expected result.. – Aravinth Kannan Aug 21 '14 at 06:52
@Mitchell what you want? do you want return rows only if the condition matched for more than one rows? – Haji Aug 21 '14 at 06:58
there are no any syntax errors and it also do what you want! it might be caused by other problems, please provide detailed error information. – Laurence Geng Aug 21 '14 at 06:52

Join two tables on two columns

0 Answers0