csql = "INSERT INTO IFCOMPAN ( CID, CNAME1, CNAME2, CADDRESS1, CZIPCODE, CLOCALITY, CVATCAT, "+; " CCUSTYPE, CSUPTYPE, CCUSCAT, CCUSPAYDELAY )"+; " ?(SELECT B.code, B.nomteleph , B.nom2 , b.rue, b.cpays + b.ccp , b.localite , 'N' , 'C' , 'U' ," csql2 = csql + " B.codePersonnel , 30 FROM BobClient AS 'B') "I never try it (can not test it right now).