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 ....