So you want only records with MyParent.the_seq = 1 and MyParent.excludeit=.T.?

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

>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