Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Matching records via a relationship
I can do this via a scan and lookup, but I think I remember 15 years ago I used to do it with a relationship and it was much faster. Can someone refresh my memory on the technique?
There are 2 tables each with an address column. Table 1 also has a logical field defaulted to false. I want to set this field to true if the address in table1 also exists in table 2. How do you set up the relationship and then mark the matching records true?
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement