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"
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