why this one not working
SELECT m.title , d.hire_date , d.first_name , d.last_name
FROM titles m
JOIN
employees d on m.emp_no = d.emp_no
WHERE d.first_name= ' margareta' AND d.last_name= 'markowitch'
1 answers ( 0 marked as helpful)
Hi Mustafa!
Thanks for reaching out.
You should remove the whitespace at the beginning of the first name and use Markovitch instead of Markowitch. Your query should be:
SELECT m.title, d.hire_date, d.first_name, d.last_nameFROM titles m JOIN employees d ON m.emp_no = d.emp_noWHERE d.first_name = 'Margareta' AND d.last_name = 'Markovitch';
Hope this helps.
Best,
Tsvetelin