Table appearing in multiple databases

2001-05-21 Thread Scott F. Crosby
Is it possible to place the same table in multiple databases, by linking the MYD file from one database to the next? I can see obvious problems with such a technique, so I thought I'd ask here. Thanks, -- Scott F. Crosby E-Mail : [EMAIL PROTECTED] Web : http://www.skroz.net "It&#

Sorting on multiple tables

2001-04-22 Thread Scott F. Crosby
mary key, modified date, ident tinytext); insert into tmp select id, timestamp, name from loc; insert into tmp select id, timestamp, title from media; insert into tmp select id, timestamp, owner from inventory; ... select * from tmp order by modified; drop table tmp; Is there an easier/faster way? Thank