Member Avatar for zaman1111

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?

  • 2 Contributors
  • 1 Reply
  • 158 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by adityabakle
Member Avatar for adityabakle

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;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.