select from tb where 条件1或条件2我只知道两个并列的条件是where 条件1and条件2，如果是或的话应该怎么写 [解决办法]
Quote: 引用:Quote: 引用:关键字 'and' 附近有语法错误。string sqlm2 = "select booktime from book where booktime=" + TextBox1.Text + " and (T1='" + Labeldet.Text + "' or T2='" + Labeldet.Text + "'）";booktime是时间类型的你单步调试，把sql语句打印出来。在逻辑运算的时候and的优先级比OR高吧，如果括号去掉的话这逻辑好混乱
Quote: 引用:关键字 'and' 附近有语法错误。string sqlm2 = "select booktime from book where booktime=" + TextBox1.Text + " and (T1='" + Labeldet.Text + "' or T2='" + Labeldet.Text + "'）";booktime是时间类型的你单步调试，把sql语句打印出来。
关键字 'and' 附近有语法错误。string sqlm2 = "select booktime from book where booktime=" + TextBox1.Text + " and (T1='" + Labeldet.Text + "' or T2='" + Labeldet.Text + "'）";booktime是时间类型的
