i need a jsp+mysql query to select data from two table for a perticular user
eg:select data from employee and leave table for john.please help me
You can use the following query:
select * from employee emp,leave l where emp.emp_id=l.emp_id;
Anyways, if the above query doesn't works for youo then provide fields of both the tables.
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.