Re: Crossdatabase queries

2001-06-01 Thread Dibo Chen
databases. > What I mean: Is it possible to write a crossdatabase > queries in MySQL? Yes, it is. Just use "select db_name.tbl_name.fld, ... from db_name, " > > thank you in advance > Adam > > create table FIELD_DESC ( > field_id SMALLINT NOT NUL

Crossdatabase queries

2001-06-01 Thread Boryniec Adam
crossdatabase queries in MySQL? thank you in advance Adam create table FIELD_DESC ( field_id SMALLINT NOT NULL, description VARCHAR (80), PRIMARY KEY (field_id) ); insert into FIELD_DESC (field_id,description) values (1,"Description of the field \"First name\" on the user reg