Resolved: subquery and cross join question

in SQL / SQL Subqueries nested in SELECT and FROM

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)

Tsvetelin Tsonkov

Instructor

Posted on:

18 Mar 2022

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

Helpful answer

Resolved: subquery and cross join question

Submit an answer

related questions