i want to get the names of all workers from a table who have joined after a particular date(eg after 1997). the table is having the name of workers who have joined from 1985 till 2000. please give me sqlcoding that can be used in jdbc. i am using MSaccess as back end.
Hello Sachin, You can use a prepared statement like this: PreparedStatement stat = myConn.prepareStatement("Select name from table where (joining_date between ? and ?)"); stat.setString(1,beginingDate); stat.setString(2,endDate); you try this and let me know whether it works. Smita