CUSTOM REPORT -Quotation

1

Hello,

doing a custom report in quotation but it doesn’t show because there is an error. please help

select *
from tabQuotation a
left join tabQuotation Item b on a.name=b.parent
left join tabItem c on c.item_code=b.item_code

What is the error?

Thank you

2

use backticks on table names like this : `tabQuotation`, `tabQuotation Item`, `tabItem`. It should be solved then.

This symbol should be avaliable top left corner of your keyboard, just below the Esc key.