SQL = "SELECT cnf_caratteristiche.*,cnf_valprod.*,cfgc_des FROM mg_grmercar,cnf_caratteristiche,cnf_grpcaratt,cnf_valprod WHERE "
                SQL = SQL & " mgrp_idcar = cnfc_id"
                SQL = SQL & " AND cfgc_id = cnfc_grpcaratt "
                SQL = SQL & " AND mgrp_id = cnfvp_grmercar"
                SQL = SQL & " AND cnfc_tpcar = '"+tipo_caratt+"' "
                SQL = SQL & " AND cfgc_tipo = '"+tipo_gruppo+"' "
                SQL = SQL & " AND cnfvp_numdoc = " & sy_cvn(dr_numdoc)
                SQL = SQL & " AND cnfvp_tipdoc = " & sy_cvs(dr_tipdoc)
                SQL = SQL & " AND cnfvp_anndoc = " & sy_cvn(dr_anndoc)
                SQL = SQL & " AND cnfvp_dcriga = " & sy_cvn(dr_riga)
                SQL = SQL & " AND mgrp_grmer = " & sy_cvn(cat_vend)