emp_no < '110010'
use employees;
select e.*,d.*
from employees e
cross join
departments d
where emp_no < '110010';
why is this not valid
3 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Hi Abdelrahman!
Thanks for reaching out.
It is because you used another emp_no in the WHERE clause.
Please, use the following code:
WHERE
e.emp_no < 10011;
Hope this helps.
Best,
Tsvetelin
Thank you for your concern
Tsvetelin Tsonkov
Instructor
Hi Abdelrahman!
You are very welcome!
Best,
The 365 Team