使用命令窗口生成SQL语言
Dim jb As New SQLJoinTableBuilder("查询表1","Sales_Order_Product")
Dim sl As String
jb.C
jb.AddTable("Sales_Order_Product","OrderId","Sales_Order_List","Id") '表Sales_Order_Product"和表"OrderId","Sales_Order_List"是关联的
jb.AddTable("Sales_Order_List","CustomerId","Customer_List","Id")
jb.AddTable("Sales_Order_Product","ProductId","Sales_Product_List","Id")
jb.AddCols("ProductId","{Sales_Product_List}.Name""SubmitDate", "Amount","Price")
sl = jb.BuildSQL()
Output.Show(sl)
Select ProductId,{Sales_Product_List}.Name"SubmitDate,Amount,Price From (({Sales_Order_Product} Inner JOIN {Sales_Order_List} ON {Sales_Order_List}.[Id] = {Sales_Order_Product}.[OrderId]) Inner JOIN {Customer_List} ON {Customer_List}.[Id] = {Sales_Order_List}.[CustomerId]) Inner JOIN {Sales_Product_List} ON {Sales_Product_List}.[Id] = {Sales_Order_Product}.[ProductId]
但是复制到窗口后会提示错误,怎么改正???
此主题相关图片如下:1.jpg
![dvubb 图片点击可在新窗口打开查看](UploadFile/2014-11/2014111417275033411.jpg)
![dvubb 图片点击可在新窗口打开查看](skins/default/filetype/jpg.gif)
此主题相关图片如下:2.jpg