Maybe an order of operations in your deploy process? That field doesn't exist yet, and so you can't join from that record tied to that field?