使用SQL查询时出现问题 [英] Problem using sql query

问题描述

我想从两个表中获取记录，我正在使用以下编码
但这是行不通的.请帮帮我

I want to get the records from Two tables I am using the Following Coding
But it is not working. Please help me

select T1.id,T1.ODate,T1.DeliDate,T1.Particulars,T1.Amount,T2.Orderid,
Coalesce(sum(T2.paidamount),0) from tbl_Hostels T1 Left Join tbl_HostelPayment T2
on T2.Orderid= T1.id where T1.Billpaid=''Cancel''  and
T1.ODate<=''" & Format(DTPFrom.Value, "MM-dd-yyyy") & "''
and T1.ODate<=''" & Format(DTPTo.Value, "MM-dd-yyyy") & "''
order by T1.id "

推荐答案

Devausha，


我认为您在约会方面遇到了问题
以yyyy-MM-dd格式放置日期

Hi Devausha,


I think you have problem with date
put date in yyyy-MM-dd format

我已解决代码正在运行，谢谢

I have Solved The code is working thank you

这篇关于使用SQL查询时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！