Inner join statement does not seem to work

Question

I have a simple SQL statement that does not seem to work. I want the of table match_team ("match_id") on the table match ("id").

Therefore I wrote the following INNER JOIN STATEMENT

 SELECT * FROM match_team INNER JOIN match ON match_team.match_id = match.id

This throws an error however. Any thoughts on what might go wrong here?

Match is a reserved word in ANSI SQL, it has to be delimited as `"match"`. — jarlh, Apr 04 '16 at 09:20
Possible duplicate of [How do I escape reserved words used as column names? MySQL/Create Table](http://stackoverflow.com/questions/2889871/how-do-i-escape-reserved-words-used-as-column-names-mysql-create-table) — sameh.q, Apr 04 '16 at 09:26
Which DBMS are you using? And what is the **exact** error message? — , Apr 04 '16 at 09:31

score 1 · Answer 1 · answered Apr 04 '16 at 09:23

1

You can use double quotes for avoiding keywords.

SELECT * FROM match_team INNER JOIN "match" ON match_team.match_id = "match".id

answered Apr 04 '16 at 09:23

FallAndLearn

4,035
1
18
24

score 0 · Answer 2 · answered Apr 04 '16 at 09:25

0

best way to avoid conflict use table with database name. assuming your database is "Master"

SELECT * FROM Master.match_team INNER JOIN Master.match ON Master.match_team.match_id = Master.match.id

answered Apr 04 '16 at 09:25

Satish Kumar sonker

1,250
8
15

jsampas · Answer 3 · 2016-04-04T09:35:17.313

0

SELECT * 
FROM match_team a
INNER JOIN [match] b ON a.match_id = b.id

edited Apr 04 '16 at 09:35

answered Apr 04 '16 at 09:26

jsampas

11
2

sagi · Accepted Answer · 2016-04-04T09:28:32.453

0

The problem is that match is a reserved word in your RDBMS, you didn't specify your RDBMS, and it really depend on it, but try one of this:

SELECT * FROM match_team INNER JOIN `match` ON match_team.match_id = `match`.id
SELECT * FROM match_team INNER JOIN "match" ON match_team.match_id = "match".id

I don't know of any SQL language that uses another character for reserved words

edited Apr 04 '16 at 09:28

answered Apr 04 '16 at 09:27

sagi

40,026
6
59
84

score 0 · Answer 5 · answered Apr 04 '16 at 09:45

First Of all check that you are using your database not the "Master" database ...

use Ctrl+u to access available databases dropdownList or try this :

use [your database name] go

SELECT * FROM match_team INNER JOIN match ON match_team.match_id = match.id

Secondary To avoid Conflicting tables use aliases ... see below for e.g. :

use [your database name] go SELECT * FROM match_team A INNER JOIN match B ON A.match_id = B.id

or start addressing with schema like : dbo.match_team.match_id = dbo.match.id

Inner join statement does not seem to work

5 Answers5

SELECT * FROM match_team INNER JOIN match ON match_team.match_id = match.id