call resultset in join query

Reply

Join Date: Aug 2004
Posts: 11
Reputation: zaman1111 is an unknown quantity at this point 
Solved Threads: 0
zaman1111 zaman1111 is offline Offline
Newbie Poster

call resultset in join query

 
0
  #1
Nov 2nd, 2004
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?
Reply With Quote Quick reply to this message  
Join Date: Aug 2004
Posts: 8
Reputation: adityabakle is an unknown quantity at this point 
Solved Threads: 0
adityabakle adityabakle is offline Offline
Newbie Poster

Re: call resultset in join query

 
0
  #2
May 1st, 2005
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;
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC