The multi-part identifier could not be bound error

[washi (Petr Hrehorovsky)]

Solution is discussed in Limits on SQL generation of lookup fields.