[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!