i'm in a situation where a sql database will contain
multiple tables with identical schema. i need to pass
on a resultset. in the past, the software talked to
some data store [not always sql databases] where all
the "rows" of a given semantic meaning existed in one
known table: one table, one query, one resultset --
no problem.
i should know, or can discover, the list of table names
containing the rows of interest at runtime.
what's got me flummoxed is how to loop these tables
and still pass on one resultset? SELECT, in sql
syntax, doesn't seem to support querying multiple tables.
nor does resultset seem to support concatenation into
one resultset.
has anyone solved this problem, or seen a reference to
a solution??
thanx,
robert young
___________________________________________________________________________
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
