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 - Experts at Building Test Data
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.
It is sorta covered in the
JavaRanch Style Guide
subject: How can we use query containing two or more tables!
How can I use two tables in a tab
Urgent ORDBMS with JDBC
no of records count in join stament
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014