SQL Syntax error in FROM clause

Question

Here is the code I'm running into an error with:

FROM
    IndexPID
    INNER JOIN Demographics ON
        IndexPID.NDoc_Number = Demographics.NDoc_Number,
    PatientSupply
    INNER JOIN Demographics ON
        PatientSupply.NDocNum = Demographics.NDoc_Number

I also tried it this way:

FROM
    IndexPID, PatientSupply
    INNER JOIN Demographics ON
        IndexPID.NDoc_Number = Demographics.NDoc_Number
    INNER JOIN Demographics ON
        PatientSupply.NDocNum = Demographics.NDoc_Number

But no cigar. Anybody tell me what I'm doing wrong?

IndexPID, Demographics and Patient Supply are tables. I need to join Demographics to IndexPID and Patient Supply on their NDoc_Number fields — eatonphil
– eatonphil, Commented Aug 20, 2012 at 20:22
The error is because you're just randomly throwing the name "PatientSupply" in random places. If it's a table name, it needs to be joined. — Paul Tomblin
– Paul Tomblin, Commented Aug 20, 2012 at 20:22

Taryn · Accepted Answer · 2012-08-20 20:22:30Z

4

You were very close:

FROM IndexPID
INNER JOIN Demographics 
   ON IndexPID.NDoc_Number = Demographics.NDoc_Number
INNER JOIN PatientSupply
   ON Demographics.NDoc_Number = PatientSupply.NDocNum

answered Aug 20, 2012 at 20:22

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KOT · Accepted Answer · 2012-08-20 20:22:08Z

4

would be easier if you posted the whole SQL!

Try

FROM
IndexPID
INNER JOIN Demographics ON
    IndexPID.NDoc_Number = Demographics.NDoc_Number
INNER JOIN PatientSupply ON
    PatientSupply.NDocNum = Demographics.NDoc_Number

answered Aug 20, 2012 at 20:22

KOT

2,1663 gold badges24 silver badges36 bronze badges

Comments

Michael Berkowski · Accepted Answer · 2012-08-20 20:29:18Z

2

You are mixing implicit (comma-separated) and explicit JOINs in an odd way here. It should look like the following, using explicit INNER JOINs only, with no commas between table names or ON clauses:

FROM
  IndexPID
  INNER JOIN Demographics 
    ON IndexPID.Ndoc_Number = Demographics.NDoc_Number
  INNER JOIN PatientSupply 
    ON PatientSupply.NDocNum = Demographics.NDoc_Number

edited Aug 20, 2012 at 20:29

answered Aug 20, 2012 at 20:22

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Comments

valex · Accepted Answer · 2012-08-20 20:30:09Z

1

You uses inner join so you can use:

FROM Demographics
inner join IndexPID on Demographics.NDoc_Number=IndexPID.NDoc_Number
inner join PatientSupply on Demographics.NDoc_Number=PatientSupply.NDocNum

answered Aug 20, 2012 at 20:30

valex

24.2k7 gold badges47 silver badges62 bronze badges

Collectives™ on Stack Overflow

SQL Syntax error in FROM clause

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related