DataTable的select方法，联合查询

[Netcean]

sql = "select a.names,b.users from a inner join b on a.id=b.id";
DataTable dt =DbHelper.GetDataTable(sql);
dt.select("a.names=aa","a.id desc");

用这样的查询，会提示找不到a.names字段，这要怎么解决？谢谢

[jiyan1221]

dt.select("names=aa","id desc")，试试看

[Netcean]

不行。。提示找不到names列

[zhkefa]

names='aa'

[jiyan1221]

。。。。。

[jiyan1221]

刚才真没注意到没加单引号，字符是要加上的。
如果用变量查询的话，就用：dt.select("names='"+ ... +"'","..")，
直接查询：dt.select("names='aa'","...")

[wuyq11]

sql = "select a.names,b.users from a inner join b on a.id=b.id";
DataTable dt =DbHelper.GetDataTable(sql);
dt.select("a.names='aa'");

[silkstockings]

sql = "select a.names as a ,b.users as b from a inner join b on a.id=b.id";
然后在DT.DELECT（“a=''”）

[kingcsx666]

[Quote=引用 2 楼 netcean 的回复:]
不行。。提示找不到names列
[/Quote]

DataRow[] drs=dt.Select("Names='aa'")

select里面是一个string对象 dt.Select(string condition)

[xray2005]

sql = "select a.names,b.users from a inner join b on a.id=b.id";
DataTable dt =DbHelper.GetDataTable(sql);
dt.select("a.names='aa'");