aspose file tools*
The moose likes JDBC and the fly likes How can we use query containing two or more tables! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can we use query containing two or more tables!" Watch "How can we use query containing two or more tables!" New topic
Author

How can we use query containing two or more tables!

rushikesh kale
Ranch Hand

Joined: Jan 25, 2005
Posts: 41

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

Joined: Jul 11, 2001
Posts: 15299
    
    6

select * from table1, table2


GenRocket - Experts at Building Test Data
Michael Matola
whippersnapper
Ranch Hand

Joined: Mar 25, 2001
Posts: 1749
    
    2
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can we use query containing two or more tables!