Bill,
Yes it can.
Most probably this can be achieved by a single SQL
statement. If not I think stored procedure would be a
faster solution.
Or you can use the results returned by one query to
construct another query statement.
Ashutosh
Bill Wyza <[EMAIL PROTECTED]> wrote:
> I am very new to servlets, and java for that matter.
>
> Can I create a one servlet that looks up data from
> more that one table?
>
> For example:
>
> Have three lookup fields all getting their data from
> different tables?
> I want to then use the three values selected to
> filter another table.
>
> Can this be done? Any examples? I am using Oracle
> database and
> JDeveloper.
>
> Thanks
> Bill
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
>
http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
>
http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
__________________________________________________
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
