Last answered:

18 Mar 2022

Posted on:

12 Mar 2022

0

Resolved: subquery and cross join question

I used a cross join to connect dept_manager with the rest of the tables and got the same results
is this valid  to use the cross join instead of a subquery?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

18 Mar 2022

0

Hi Doaa!
Thanks for reaching out.

Yes, you can use instead of a subquery a CROSS JOIN between the tables.

Hope this helps.
Best,
Tsvetelin

Submit an answer