Hi to all,

I need a little help about a "where clause".
In a form I use only one SQL table, i.e named cTable.

I have created two CA,i.e named caTable1 and caTable2, with the same Select like this:
Select cTable.code, cTable.descr, cTable.perc1, cTable.perc2, cTable.appcode from cTable

The cursor caTable2 is used in the form in order to create a PickList for Field appcode in cTable.

I need to create in the caTable2 a "where" clause that satisfy these rules when appcode in the Form is not null:
1) The perc1 in the caTable2 must be equal to perc1 in caTable1
2) the perc2 in the catable1 must be equal to ZERO.

I am a neophite in VFP with SQL, and I hope in your help in order to resolve this question.

Thank you and Best Regards.