• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

how i can retrieve two tables from database

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You have two choices:
  • issue two select statements, selecting all you need from each table
  • create a query joining the results from both tables

  • Which is it you want to do?
     
    I am not young enough to know everything. - Oscar Wilde This tiny ad thinks it knows more than Oscar:
    Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
    https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    reply
      Bookmark Topic Watch Topic
    • New Topic