General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only