| Author |
how i can retrieve two tables from database
|
leela mohan
Greenhorn
Joined: Oct 31, 2006
Posts: 13
|
|
suppose the two tables have the same like this one table is create table StudentAdmissionTable ( Std_AdmNumber Number, Std_Wing varChar2(10), Std_Class varChar2(10), Std_Section varChar2(5), Std_RollNo varChar2(10), Std_AcadYear Date, std-name varchar2(8) ); another table is create table FeeDetailsTable ( Std_AdmNumber Number, Term1 Number, Term2 Number, Term3 Number, Due_Date_term1 Date, Paid_Date_term1 Date); so please tell me
|
 |
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
You have two choices: issue two select statements, selecting all you need from each tablecreate a query joining the results from both tables Which is it you want to do?
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
 |
 |
|
|
subject: how i can retrieve two tables from database
|
|
|