Query Report: Pending Purchase Request

[Aditya Duggal]

Hi,

I am trying to make this query report but I am unable to get the report to run. Please let me know where am I wrong on this one:

select
 `tabPurchase Request`.`name` as "Indent No",
 `tabPurchase Request`.`transaction_date` as "Indent Date",
 `tabPurchase Request Item`.item_code as "Item Code",
 `tabPurchase Request Item`.`description` as "Description",
 `tabPurchase Request Item`.`qty` as "Qty",
 `tabPurchase Request Item.`uom` as "UoM",
 `tabPurchase Request Item`.`ordered_qty` as "Ordered"

from
 `tabPurchase Request`,`tabPurchase Request Item`
where
 `tabPurchase Request Item`.`parent` = `tabPurchase Request`.`name`
 and `tabPurchase Request`.status = "Submitted"
 and `tabPurchase Request`.transaction_date <= curdate()
 and ifnull(`tabPurchase Request Item`.ordered_qty,0) < ifnull(`tabPurchase Request Item`.qty,0)
 and `tabPurchase Request`.status = "Submitted"
order by `tabPurchase Request`.`transaction_date` desc