mysql - SQL 查询报表内连接

Question

我想按日期获取报告，我想 INNERJOIN 购买的物品和库存，但我似乎弄错了这是我的代码：

$query=mysqli_query($con,"select month(tblpurchase.PostingDate_p) as mnth,year(tblpurchase.PostingDate_p)
 as yearr,day(tblpurchase.PostingDate_p) as date,tblpurchase.Itemname as itmname, tblpurchase.Quantity as
 pquantity, tblpurchase.Damaged as dmgq, from tblpurchase  INNER JOIN tblitem ON tblpurchase.ItemId = 
tblitem.id where date(tblpurchase.PostingDate_p) between '$fdate' and '$tdate'");

这是我的桌子

项目

id|ItemName|beginv|stock|PostingDate

tbl购买

id|Itemname|ItemId|Quantity|Damaged|LatestInv|PostingDate_p|UpdatingTime

标签： mysqlsqlinner-join

Answer 1

运行这个，最后一个返回的 clum 之后不需要逗号

$query=mysqli_query($con,"select month(tblpurchase.PostingDate_p) as mnth,year(tblpurchase.PostingDate_p)
 as yearr,day(tblpurchase.PostingDate_p) as date,tblpurchase.Itemname as itmname, tblpurchase.Quantity as
 pquantity, tblpurchase.Damaged as dmgq from tblpurchase  INNER JOIN tblitem ON tblpurchase.ItemId = 
tblitem.id where date(tblpurchase.PostingDate_p) between '$fdate' and '$tdate'");