Doaa Osman
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

18 Mar 2022

 Posted on:

12 Mar 2022
0

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

Helpful answer

Submit an answer

related questions

Islam Elkhateeb
3
26
Resolved: can't add row, I do may trail and it all back with errors
Alessandro Imbrìaco
2
26
Resolved: Explanations to questions 15 and 29
Alessandro Imbrìaco
2
20
Resolved: Can't understand what LEFT JOIN does
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Davide Sanchioni
0
14
Resolved: SQL Exam question number 29
Romeo Thomas
0
10
LEFT JOIN - Part I error
Dhanush Kumar S
0
8
Question no 2 - First blocker
Nourhan Osama Ahmad
0
8
how to upload the assignment and remark on it 
Maxime Darbouze
0
8
I wrote the same command that is the sql file and it did not work
Maxime Darbouze
0
8
1681 Integer display width is deprecated and will be removed in a future release.
Kiran B
0
8
Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each
Islam Elkhateeb
0
8
Resolved: Fixed Number of Row retrieved from each of my between and And query