Multiple database - connection EQ not working 关注
We are trying to work with mutiple databases. So we added both, now we need to define the connection between. Linkage is one field (delivery note).
Delivery note some fields
Delivery note some more fields
So we say: database1.dnote EQ database2.dnote --> no printout, strange, as in both files we have the same dnote number (as the only entry, 2000).
Next test, we added some more fake dnotes to database 2, all higher than the origin (e.g. 2000, 2001, 2002, 2003)
Now my connection is db2.dnote <> db1.dnote
=> result: I have 3 printouts (dnote 2001, 2002, 2003)
Next test, now my connection is db2.dnote >= db1.dnote
=> result, I have 4 printouts (dnote 2000, 2001, 2002, 2003).
So in this case, the EQ seems to work?