select...where 语法求助

cbn4444

SQL.Add('select distinct code from alldata where type='''+ComboBox2.Text+''' and group='''+ComboBox3.Text+'''');提示说语法错误。但是若where后面只挂一个条件SQL.Add('select distinct code from alldata where type='''+ComboBox2.Text+''' ');就可以正常运行。不知哪里写错了

dps521

不会

FlyCode

应该是末尾多了个双引号
SQL.Add('select distinct code from alldata where type='''+ComboBox2.Text+''' and group='''+ComboBox3.Text+'');