Click here to Skip to main content
15,614,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Select name, Id from table1;

 select colum1,colum2 from table2 where name='' and id='' ----output from the first table

need to take the output from the table2 from all the values from table1

What I have tried:

need to join the fist query with the second and take the output
Updated 28-Jun-22 1:37am

1 solution

You can use the concept of Sub-Queries and join to your results - see Oracle Subquery Made Easy[^]

If you are not familiar with joins you can also look at Oracle Joins: A Visual Explanation of Joins in Oracle[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900