Hi Brent,
You might try creating the table you want(if it does not already exist) and appending to it.
create table tablename(fields attribute(size));
sele tablename;
append from othertable
append from othertable2

and so on

if you need one of the fields to identify which table it came from you could use a select statement first adding the field with the value you want.

Select *,1 as tableid from othertable into anothertable
select *,2 as tableid from othertable2 into anothertable2

then append to the tablename table with the newly created tables
Don't know if this is what you were looking for, but hope it helps
James