display records from multiple tables in a single table

  • Thread starter Thread starter Tom Gahagan
  • Start date Start date
T

Tom Gahagan

"Gary Ameye" wrote in message
Can frontpage 2002 display records from two tables
simultaneously in a third table? If so, what would be
the correct syntax for example above? If not, is this
supported in the new frontpage 2003?
Click to expand...

Not sure it can be done in FP... but....

You CAN do this with asp (or php if you are on unix,etc) Probably not the
answer you were looking for but not all THAT hard to learn if you've got the
time. (and who does?) :)

Tom Gahagan
 
Frontpage 2002/server extensions provides an interface to
display records from a single table in Access. I would
like to display records from multiple tables in a single
summary table. I tried to create a custom query via the
frontpage interface with two selects as follows:

SELECT product FROM table1
SELECT product FROM table2

Each select works fine by itself, but when I use them
together, I get a warning that the server encountered an
error while processing a database request.

Can frontpage 2002 display records from two tables
simultaneously in a third table? If so, what would be
the correct syntax for example above? If not, is this
supported in the new frontpage 2003?
 
Thanks for responding Tom. I figured it out anyway - you
can use a Frontpage asp page and a query statement
containing the "union all" syntax to display data from
multiple tables. I'm all set.

Gary
 
Back
Top