sql中的join
string   sql= "select   orderdetail.*,   order.postdate,member.UserName   from   orderdetail   inner   join   member   on   order.id=   member.id   inner   join   order   on   order.id=orderdetail.id   ";


这条语句错在什么地呢....大家大哥大姐们,帮帮忙.

------解决方案--------------------
报什么错??
------解决方案--------------------
你是用在ACCESS中吧。

try

select orderdetail.*, order.postdate,member.UserName from (orderdetail inner join member on order.id= member.id) inner join order on order.id=orderdetail.id
------解决方案--------------------
string sql= "select orderdetail.*, order.postdate,member.UserName from orderdetail inner join order on order.id=orderdetail.id inner join member on order.id= member.id ";

------解决方案--------------------
我上面不是寫了方法嗎？

ACCESS中多表關聯的寫法和在MS SQL中的寫法有區別的。

select orderdetail.*, order.postdate,member.UserName from (orderdetail inner join member on order.id= member.id) inner join order on order.id=orderdetail.id
------解决方案--------------------
string sql= "select orderdetail.*, order.postdate,member.UserName from orderdetail inner join order on order.id= member.id inner join order on member.id=orderdetail.id where id= "+ Request.QueryString[ "ID "]+ " "

-----------
你這寫的什麼語句？

關聯了order兩次，卻沒有關聯member表。

try

string sql= "select orderdetail.*, order.postdate,member.UserName from (orderdetail inner join order on order.id= orderdetail.id) inner join member on member.id=orderdetail.id where orderdetail.id= "+ Request.QueryString[ "ID "]+ " ";............
------解决方案--------------------
paoluo(一天到晚游泳的鱼) 的意见不知道对不，try

where id= "+ Request.QueryString[ "ID "]+ " ";............

感觉没有写清楚是哪个表的id
------解决方案--------------------
nyzfl(小丫头是我心爱的女人 My-Blog地址:http://blog.csdn.) ( ) 信誉：96 Blog 加为好友 2007-06-25 11:12:22 得分: 0


paoluo(一天到晚游泳的鱼) 的意见不知道对不，try

where id= "+ Request.QueryString[ "ID "]+ " ";............

感觉没有写清楚是哪个表的id


---------
這裡的確有問題，所以我加上了“orderdetail.”。
------解决方案--------------------
在每个表，每个字段名上加上 "[] "，如
select [orderdetail].*, [order].[postdate],[member] ....
order是关键字，在ACCESS中无法区别，就报错了
在SQLSERVER中是可以识别的
------解决方案--------------------
的確是這個問題，不過這麼修改一下即可.

string sql= "select orderdetail.*, order.postdate,member.UserName from (orderdetail inner join [order] on order.id= orderdetail.id) inner join member on member.id=orderdetail.id where orderdetail.id= "+ Request.QueryString[ "ID "]+ " ";