Doubt in Oracle Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • padmanabhanp
    New Member
    • Nov 2006
    • 14

    Doubt in Oracle Query

    Hai,
    I am having two tables. one is login table and another one is newemployee table.

    Login Table:
    create table Login(UserType varchar(30),Use name varchar(30),Pas sword varchar(30),Use rname datetime,Logout Time datetime,LoginD ate datetime)

    NewEmployee Table:
    create table NewEmployee(Tit le varchar(30),Ful lName varchar(30),IdN o varchar(10),Cat egory varchar(50),Dep artment varchar(50),Emp loymentType varchar(30),Sub admin varchar(30))

    what i want is, i want to select the details of Username,Logout Time, LoginDate in Login table where Username="aa" and Fullname in NewEmployee table where
    subamin="aa"
  • sahaya rekha
    New Member
    • Apr 2007
    • 1

    #2
    Originally posted by padmanabhanp
    Hai,
    I am having two tables. one is login table and another one is newemployee table.

    Login Table:
    create table Login(UserType varchar(30),Use name varchar(30),Pas sword varchar(30),Use rname datetime,Logout Time datetime,LoginD ate datetime)

    NewEmployee Table:
    create table NewEmployee(Tit le varchar(30),Ful lName varchar(30),IdN o varchar(10),Cat egory varchar(50),Dep artment varchar(50),Emp loymentType varchar(30),Sub admin varchar(30))

    what i want is, i want to select the details of Username,Logout Time, LoginDate in Login table where Username="aa" and Fullname in NewEmployee table where
    subamin="aa"
    u

    u want to select from two differnt tables na how the problem comes

    Comment

    • hirak1984
      Contributor
      • Jan 2007
      • 316

      #3
      but where are these two tables connected?

      you didnt make any foreign key,did you?
      And please post this to oracle forum,they may answer you better
      Originally posted by padmanabhanp
      Hai,
      I am having two tables. one is login table and another one is newemployee table.

      Login Table:
      create table Login(UserType varchar(30),Use name varchar(30),Pas sword varchar(30),Use rname datetime,Logout Time datetime,LoginD ate datetime)

      NewEmployee Table:
      create table NewEmployee(Tit le varchar(30),Ful lName varchar(30),IdN o varchar(10),Cat egory varchar(50),Dep artment varchar(50),Emp loymentType varchar(30),Sub admin varchar(30))

      what i want is, i want to select the details of Username,Logout Time, LoginDate in Login table where Username="aa" and Fullname in NewEmployee table where
      subamin="aa"

      Comment

      Working...