I have a SQL query: SELECT * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID=Requester_Reco rd.Requester_ID; if i want to call an attribute from Job_Request_Record table e.g. rs.getString("ID")is it valid? or anything else. please help.

Also, is it possible to have a create view table in ms access 2003?

What is your requirement?

You can refer at
http://java.sun.com/docs/books/tutor...ics/joins.html

for join query & resultSet

Gokulan Ethiraj

As long as the column "ID" is returned to the record set you should be able to use rs.getString("ID")
As you are using a wildcard, i.e. SELECT * then you should be returning all columns.

As for the create table question, I am sure it is possible, but you would be better looking for SQL tutorials.