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

[foamy]

Hi guys,

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

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

What am I doing wrong here?

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!

[Nightwolf629]

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

[eclipsed4utoo]

try this instead...

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

[foamy]

try this instead...

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...

[Homogenn]

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

[foamy]

Thanks,

looking at my first query that seems really obvious now