Hello all,
I am fairly new to MySQL. I have a problem, that I have not been able to
figure out. I've tried searching the net and reading the manual, but all to
no avail.
I have two databases (A and B) which have the same structure but different
field names. The code from mysqldump follows (comments removed for
brevity):
CREATE TABLE a (<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />
aID char(3) default NULL,
aDate date default NULL,
aCmnt varchar(20) default NULL
) TYPE=MyISAM;
INSERT INTO a VALUES ('123','2003-01-01','comment a-1');
INSERT INTO a VALUES ('124','2003-01-04','comment a-2');
CREATE TABLE b (
bID char(3) default NULL,
bDate date default NULL,
bCmnt varchar(20) default NULL
) TYPE=MyISAM;
INSERT INTO b VALUES ('222','2003-01-02','comment b-1');
INSERT INTO b VALUES ('223','2003-01-03','comment b-2');
What I want to do, is create a select statement which pulls info from both
databases and displays it sorted by date. So, I should end up with records
in the following order:
123, 2003-01-01, comment a-1
222, 2003-01-02, comment b-1
223, 2003-01-03, comment b-2
124, 2003-01-04, comment a-2
Any help will be appreciated. Thanks in advance,
Jay
