Information générale
Catégorie:
Codage, syntaxe et commandes
>>want to refine my question. now i see the bigger picture.
>>
>>Want a sql result set that contains certain records from table1, and have matching records from table2.
>>
>>currently i have an sql that selects the desired records from table1. then i loop and readi each of those records and seek against table2. if the seek is not successful then i delete the result record. taking about 1 minute.
>>
>>any ideas how to make this more efficient.
>>
>>brenda
>Select * From Table1 where MatchKey IN (Select MatchKey From Table2)
having trouble with the actual sql syntax.
select * from table1 where field1 = .t. into resulttable
now only want the rows from resulttable that have a match on field2 and field3 in table2.
obviously i would prefer to get both things done in a single statement, if possible. this is just the easiest way for me to explain it.
thanks brenda
Précédent
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