对内存中的表执行SQL查询
本文关键字:执行 SQL 查询 内存 | 更新日期: 2023-09-27 18:10:14
我有2个表,我已经使用SQL查询
DataTable Table = Select FacilityIssueDetails.FacilityNo,LCPaymentDetails.BillNo, FacilityIssueDetails.FStatus,LCPaymentDetails.BankName , LCPaymentDetails.Supplier, FacilityIssueDetails.BaseAmount,FacilityIssueDetails.Currency, FacilityIssueDetails.FacilityAmountINR, LCPaymentDetails.PAmountINR , FacilityIssueDetails.LCAmountPaid, FacilityIssueDetails.LCAmountRemaining,FacilityIssueDetails.IssueDate, FacilityIssueDetails.ExpiryDate, LCPaymentDetails.LCNo
from FacilityIssueDetails,LCPaymentDetails
where FacilityIssueDetails.FacilityNo = LCPaymentDetails.LCNo
现在我想对存储在内存中的表运行另一个SQL查询。
怎么做?这是一个select查询。
请帮忙,提前感谢。
使用DataTable。选择方法。注意,与SELECT
对数据库的性能比较,它的性能较慢。