I am trying to bulid report and here it sounds like I mistaken in syntax of sql
can anyone tell me the right syntax
I am trying to bulid report and here it sounds like I mistaken in syntax of sql
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'
Thank u very much
can you tell me the syntax if I will use parameter please