* Brad Tilley 

> > create table computers
> > select * from desktops, laptops where
> > desktops.field_1 = laptops.field_1
> > ...

> Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't 
> supported on this version.

You can do it in two steps:

CREATE TABLE computers SELECT * FROM desktops;
INSERT computers SELECT * FROM laptops;

-- 
Roger

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to