Beginner Problems with SQL


#1

Hello. I’m a newbie at codecademy and am facing some issues in Table Transformation . I don’t get how outer query is linked with inner subquery. Can someone explain transforming tables to me, please?
Regards.


#2

Please assist us by including a link to the lessn you are having difficulty with.


#3

Thank you for your concern mtf. It is particularly this one and the ones ahead. The code gets difficult all of a sudden and I was unable to grasp how things relate to each other at this point.


#4

this one isn’t a link to the exercise? Please include link/url to exercise, so we can easily access the lesson, study the information and instructions to help you further


#5

https://www.codecademy.com/courses/sql-table-transformation/lessons/subqueries/exercises/non-correlated-iii?action=resume_content_item

here is the url


#6

I think this will solve your problem.

Select name,mobile from (Select name,city,mobile,address,pin_code from table2);

Another Example

Select name,city,mobile,address,pin_code from table2 where city in (select city from table3);

There are many example to this for more .Learn PLSQL


#7

I don’t how this helps. :s


#8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.