Make sure that the two tables are absolutely identical with the columns in the same order with the same names. Better yet, specify the columns rather than using * and the insert will not break if you modify one of the tables.
"Plateautel.net" <[EMAIL PROTECTED]> wrote: >My question evidently got lost somewhere, so I'll ask again. > > >Can someone tell me what is wrong with this code? > >I get an error "Invalid use of escape character like operator(716) > >Insert into no_150 + >Sel * + >from services + >whe Unit = '102' and + >Svc_begin_dte between .vstartqtr2 and .vstopqtr2 and + >Case_no not in + >(sel Case_no from services whe Svc_code = '150' and + >Svc_begin_Dte between .vstartqtr and .vstopqtr) > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
