SQL查询语句语法错误,找不出来!请教高手!
string cmdText = "select attentiontime, nickname, message from message,person where attentiontime>=" + DateTime.Now + " and attentiontime=<" + DateTime.Now.AddDays(1) + " and message.personid=person.id";
语法错误:
where attentiontime>=" + DateTime.Now + " and attentiontime=<" + DateTime.Now.AddDays(1) + " and message.personid=person.id";