MSSQL - 视图操作
查询语句(包含使用Where子句):
1 string sql = @"SELECT TableName, TablePosition,TableSate, TabelType,OpenTime, GuestName, WaiterName, Remark FROM View_TableGuest WHERE TableName = '" + name + "'";
*:两张表之间要有相等的字段,这样才能查询出记录。
posted on 2015-06-06 14:46 ultrastrong 阅读(507) 评论(0) 编辑 收藏 举报