Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
A parent file sp has a related child file SPLK. There can only be one record per SP in SPLK. Only some SP records have an SPLK entry. I am using the command: SELECT * FROM sp INNER JOIN splk ON splk.spcode = sp.spnumber where &customcomx INTO CURSOR TEMPCURSOR ... with the two files aliased SP and SPLK opened. This does not work correctly with a search that only refers to fields in SP AND if the related file SPLK lacks records for SP records. I noticed this using a LIKE clause in the WHERE clause (&customcomx). The &customcomx command in question was "sp.sp1 LIKE '%luzon%'"
Is there a way around this? Thanks in advance ....
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