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)
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