Last answered:

10 May 2023

Posted on:

02 May 2023

0

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)
Posted on:

03 May 2023

0

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

Posted on:

03 May 2023

0

Thank you for your concern

Posted on:

10 May 2023

0

Hi Abdelrahman!
You are very welcome!
Best,
The 365 Team

Submit an answer