Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can we use query containing two or more tables!

 
rushikesh kale
Ranch Hand
Posts: 41
Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys!
In my interview one of the interviewer ask me the question :"how can we use single query having two tables name in that?"
Can anybody suggest how to do this!

Thanks in advanced!
Regards
Rushikey
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
select * from table1, table2
 
Michael Matola
whippersnapper
Ranch Hand
Posts: 1817
4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Note that in the vast majority of queries involving more than one table, you'll want to perform some sort of join on the tables.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic