[RESOLVED] The multi-part identifier could not be bound.

Hi guys,

I'm trying execute the statement below, but I keep getting the error:

Quote:

---

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "SALESTABLE.SALESNUMBER" could not be bound.

---

What am I doing wrong here?

Code:

---

SELECT SALESTABLE.*, SALESTRANS.*, DEBINVJOUR.*, EXCHANGECODERATE.*
FROM SALESTRANS
INNER JOIN DEBINVJOUR ON SALESTABLE.SALESNUMBER = DEBINVJOUR.SALESNUMBER
INNER JOIN SALESTABLE ON SALESTRANS.SALESNUMBER = SALESTABLE.SALESNUMBER
INNER JOIN EXCHANGECODERATE ON SALESTABLE.EXCHANGECODE = EXCHANGECODERATE.EXCHANGECODE
WHERE SALESTABLE.DEBTORACCOUNT = ' 42914411'
ORDER BY SALESTABLE.CREATEDATE

---

Thanks in advance!

Seems like a lot of things could cause that.

Not sure what it could be myself, but this was suggested for this error on another forum:

1) Check all qualifiers (all owners and tables and columns are valid)
2) Check that all derived tables has a name
3) All columns in a derived table has a name



in that example, the problem ended up being a case-sensitive issue
he had RescAddon but it should have been RescAddOn


... hope that helps

try this instead...

Code:

---

SELECT SALESTABLE.*, SALESTRANS.*, DEBINVJOUR.*, EXCHANGECODERATE.*
FROM SALESTRANS
INNER JOIN DEBINVJOUR ON SALESTRANS.SALESNUMBER = DEBINVJOUR.SALESNUMBER
INNER JOIN SALESTABLE ON SALESTRANS.SALESNUMBER = SALESTABLE.SALESNUMBER
INNER JOIN EXCHANGECODERATE ON SALESTABLE.EXCHANGECODE = EXCHANGECODERATE.EXCHANGECODE
WHERE SALESTABLE.DEBTORACCOUNT = ' 42914411'
ORDER BY SALESTABLE.CREATEDATE

---

I changed the first inner join

Quote:

---

Originally Posted by eclipsed4utoo

try this instead...

Code:

---

SELECT SALESTABLE.*, SALESTRANS.*, DEBINVJOUR.*, EXCHANGECODERATE.*
FROM SALESTRANS
INNER JOIN DEBINVJOUR ON SALESTRANS.SALESNUMBER = DEBINVJOUR.SALESNUMBER
INNER JOIN SALESTABLE ON SALESTRANS.SALESNUMBER = SALESTABLE.SALESNUMBER
INNER JOIN EXCHANGECODERATE ON SALESTABLE.EXCHANGECODE = EXCHANGECODERATE.EXCHANGECODE
WHERE SALESTABLE.DEBTORACCOUNT = ' 42914411'
ORDER BY SALESTABLE.CREATEDATE

---

I changed the first inner join

---

That seems to have done it :) Thanks!

What was the nature of my error? I'm new to join-statements...

You wrote SALESTABLE instead of SALESTRANS in the first INNER JOIN.

Thanks,

looking at my first query that seems really obvious now :D