SQL JOIN Syntax Error with Multiple Joins

Question

SELECT
    *
FROM
    [SQL].[dbo].[Debtors] d
JOIN 
    [SQL].[dbo].[DebtorIndex] di
JOIN 
    [SQL].[dbo].[DebtorAddresses] da ON d.IDNumber = di.IDNumber
                                     AND d.AutoNumber = da.DebtorID
                                     AND da.DebtorID = '199'

I am getting this error

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'da'.

First however there is nothing there. Is there supposed to be something else there?

Second for [SQL].[dbo].[Debtors] d, I know for a fact and have triple checked that d.IDNumber & d.AutoNumber exist but I get the following error for both

"The multi-part identifier "d.IDNumber" could not be bound."

and get the same for d.AutoNumber.

Please help. Thanks in advance

What is the difference between AutoNumber and IDNumber? It sounds like they're both IDENTITY or primary-key attributes, in which case one is redundant. Also avoid using the term "Autonumber" as it doesn't apply to SQL Server. — Dai
– Dai, Commented Oct 28, 2017 at 5:44
That is a field that is in my data and is used as it is unique — Paul
– Paul, Commented Oct 28, 2017 at 14:36

kjmerf · Accepted Answer · 2017-10-28 05:46:57Z

3

Try it like this:

SELECT *
FROM [SQL].[dbo].[Debtors] d
INNER JOIN [SQL].[dbo].[DebtorIndex] di ON d.IDNumber = di.IDNumber
INNER JOIN [SQL].[dbo].[DebtorAddresses] da ON d.AutoNumber = da.DebtorID
WHERE da.DebtorID = '199'

answered Oct 28, 2017 at 5:46

kjmerf

4,3853 gold badges24 silver badges29 bronze badges

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

2 Comments

Paul Over a year ago

I did that but nothing shows up. When you type '199' something should show up when i do the searches manually however get no results when I do it with this sql statement

kjmerf Over a year ago

I'd have to look at the data to answer why

Goose · Accepted Answer · 2017-10-28 06:17:08Z

1

You don’t have a join condition on di.

... di on d.something = di.anotherthing

answered Oct 28, 2017 at 6:17

Goose

5463 silver badges7 bronze badges

Collectives™ on Stack Overflow

SQL JOIN Syntax Error with Multiple Joins

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related