我在Windows中使用访问数据库在C＃中创建水晶报表 [英] I am create crystal report into C# in windows from I have useing access database

问题描述

我正在使用Access数据库生成语法错误错误缺少操作符如何解决..





这是我的查询， ，


从saledetail选择Customer_detail.c_id，Productdetail.p_id，Productdetail.pro_name，Productdetail.rate，Customer_detail.c_name INNER JOIN Productdetail ON saledetail.p_id = Productdetail.p_id INNER JOIN Salesbill on Salesbill.s_id = saledetail.s_id内部联接Customer_detail on saledetail.c_id = Customer_detail.c_id，其中Salesbill.billno = 30;





请停止我...



我尝试过：



我尝试了很多次......

我加入了四个表和显示到Crystal Report Generate。

I am Useing Access Database in Generate Error of Syntax Error Missing operator how to Solve ..


This is My Query,,

select Customer_detail.c_id,Productdetail.p_id,Productdetail.pro_name,Productdetail.rate,Customer_detail.c_name from saledetail INNER JOIN Productdetail ON saledetail.p_id=Productdetail.p_id INNER JOIN Salesbill on Salesbill.s_id=saledetail.s_id Inner join Customer_detail on saledetail.c_id=Customer_detail.c_id where Salesbill.billno=30;


Please Halp Me...

What I have tried:

I am try to many Time...
I am join of Four Table and Display into Crystal Report Generate.

推荐答案

试试这个，我认为这会有所帮助。

Try This, I think it will be helpful.

select 
Customer_detail.c_id,
Productdetail.p_id,
Productdetail.pro_name,
Productdetail.rate,
Customer_detail.c_name 
from 
((saledetail INNER JOIN Productdetail ON saledetail.p_id=Productdetail.p_id)
			 INNER JOIN Salesbill on Salesbill.s_id=saledetail.s_id)
			 Inner JOIN Customer_detail on saledetail.c_id=Customer_detail.c_id 
where 
Salesbill.billno=30;

这篇关于我在Windows中使用访问数据库在C＃中创建水晶报表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！