Your Query:

SELECT * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID = Requester_Reco rd.Requester_ID;

Now you want to use the scriplet
<%
rs.getString("ID");
%>

use this query id you want Job.... ID

SELECT (Job_Request_Record.Job_Requester_ID) as ID, * FROM Job_Request_Record, Requester_Record WHERE Job_Request_Record.Job_Requester_ID = Requester_Reco rd.Requester_ID;