mysql如何选择多个表_从两个表mysql中选择多行

我试图从拖拽表中选择多行：

第一个表是捐助者

CREATE TABLE donor(

donor_number INT NOT NULL AUTO_INCREMENT,

d_name VARCHAR(30) NOT NULL,

mobile_number INT NOT NULL,

blood_group VARCHAR(20) NULL,

dob DATE NOT NULL,

gender ENUM('male','female') NOT NULL,

govid INT(10) NOT NULL,

PRIMARY KEY (donor_number )

);第二张桌是血统

CREATE TABLE blood_donation(

donor_number INT NOT NULL,

date_of_donate DATE NOT NULL,

blood_group VARCHAR(20) NULL,

serial_number INT(10) NOT NULL,

blood_component ENUM('wb','prcb') NOT NULL,

PRIMARY KEY (donor_number , date_of_donate ),

FOREIGN KEY (donor_number) REFERENCES donor(donor_number)

);用这个select语句：

SELECT

serial_number,

blood_group

FROM blood_donation

WHERE date_of_donate = '2012-07-18'

UNION ALL

SELECT

blood_group

FROM donor

WHERE donor.donor_number=blood_donation.donor_number;但是，我得到错误

SQL state 42S22: Unknown column 'blood_donation.donor_number' in 'where clause'

any idea????