executing a statement !!!!!!!

[Seetharaman Venkatasamy]

Hi All,

when i try to execute below query in jdbc..i get error that:

java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'emp'.

but it is executing in sqlserver window..
what is the problem..

any one please explain me..how to get the resultset?
--------------------------------------------------------
select emp.employeeid,emp.name,emp.experience,emp.phone,
emp.email,dep.depname dn,emp.fathername,emp.taddr,emp.paddr,
emp.skills,emp.qualification,emp.dob,emp.gender,emp.maritals,emp.dateofjoin
from employeetable emp,departments dep where emp.depid=dep.depid;
-------------------------------------------------------------

thanks & regards,
seetharaman

[Seetharaman Venkatasamy]

Hi All,

i find the error..problem is my code only...i rearrange the code now it is working..

thanks & regards,

seetharaman

[Muhammad Saifuddin]

i find the error..problem is my code only...i rearrange the code now it is working..

:thumb: