i have two tables employee and adduser insert into adduser(Emp_Id,Ename,Designation,Password,ReTypePassword)values('6867678po',(select Ename from employee),(select Designation from employee),'bbbb','bbbb'); so this syntax is possible to use in jsp code
based on employee id ename and designation are displayed how it is possible in jsp
employee->(Ename varchar(30),Address varchar(256),Designation varchar(32),DateOfJoining date,ContactNumber numeric(12),PANNumbernumeric(15),Emp_Id varchar(50) primary key)this is employee table schema in mysql adduser->(Emp_ID varchar(50),Ename varchar(30),Designation varchar(32),Password varchar(10),ReTypePassword varchar(10)) this is adduser table schema in mysql
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.