Perhaps someone can help me with this Select SQL statement.

What I am after is this: if MyParent.the_seq = 1, then I want it included in the cursor. However, if MyParent.excludeit = .f. then I do not want it included in the cursor.

The following doesn't give the correct results

SELECT *;
 FROM  appdata!MyParent ;
  INNER JOIN appdata!MyChild ;
   ON  MyParent.idnumber = MyChild.idnumber;
 WHERE MyParent.the_seq = 1 ;
   AND MyParent.excludeit = .f.

Any help is appreciated.

Mel Cummings