* 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]