>hi,
>I want to ask a favor I have a little problem, after an insert via a select sql, I have to update two fields with conditions on the same table where I do the insert, and I can not find a way to do it, here is the way insert table after
>

>idmatric           year      document    month     ncf     invoice     tipncf
>2001-2818     2010     c00023467     9          0          0                 01
>2002-2822     2010     c00023468     9          0          0                 01    
>2003-2188     2010     c00023469     9          0          0                 02
>2004-2518     2010     c00023410     9          0          0                 01    
>2005-2918     2010     c00023411     9          0          0                 15
>2006-2218     2010     c00023412     9          0          0                 02
>2007-2814     2010     c00023413     9          0          0                 02    
>2008-2812     2010     c00023414     9          0          0                 02
>2009-2319     2010     c00023415     9          0          0                 01
>

>I will update the invoice and ncf fields, depending on the field tipncf, information about the tables involved in this process.
>students, fees, ncfs
>
>idmatric primary students is key, tipncf is the same but in ncfs any data missing please tell me

Hi Jose,

Are you talking about SQL Server or VFP table? Can you update these two fields while inserting data?