Try ERPNext Buy Support Partners Foundation

Sql syntax on report

I am trying to bulid report and here it sounds like I mistaken in syntax of sql


can anyone tell me the right syntax

Looks like you have a problem with your SQL string query. It would help if you will also post your code here.

select tabEmployee.first_name,tabEmployee.employee from tabEmployee
where tabEmployee.date_of_birth = ‘01-01-1990’;

Hi, @silocoegypt, please find below script.

SELECT first_name as 'First Name', date_of_birth as 'Birth Date' FROM `tabEmployee`  WHERE  
date_of_birth = '1960-10-17'

1 Like

Thank u very much

can you tell me the syntax if I will use parameter please