A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How can we use query containing two or more tables!
Joined: Jan 25, 2005
May 02, 2005 09:49:00
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!
Joined: Jul 11, 2001
May 02, 2005 10:04:00
select * from table1, table2
GenRocket - A Test Data Generation Platform
Joined: Mar 25, 2001
May 02, 2005 10:52:00
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:
subject: How can we use query containing two or more tables!
How can I use two tables in a tab
no of records count in join stament
Urgent ORDBMS with JDBC
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014