Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 tables, Same records, How seek with SELECT?
Message
 
À
10/11/1997 14:07:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00059325
Message ID:
00059474
Vues:
40
>>How know which records are (aren't) in another table?
>>Using SELECT query?
>>And when you need more than one criteria?
>
>First, let me make sure that I understood your question correctly. I assume that you have two almost identical tables and you want to retrieve records from table1 which are missed in table2. If it's really so, you run following query:
>Select * from Table1 ;
>Where Table1.Primarykey NOT IN (Select PrimaryKey From Table2)
Yes, I understand your point.
But, what I have to do, when I haven't absolutely identical tables?
And what is worse I haven't one Key.
I must seek in one table from another one by 3 or more related keys.

And query:
Select * from Table1 ;
where Table1.Key1+Table1.Key2+Table1.Key3 NOT IN ;
(Select Table2.Key1+Table2.Key2+Table2.Key3 From Table2)
is notsatisfactory for me.
Do you understand me?
Giedrius
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform