Ok, I used this code to get partially what i wanted:
SELECT [Type], [Date]
FROM [Driver's License]
Where [Date]<DATE()+30
UNION SELECT[Type], [Date]
FROM [Driving Record]
Where [Date]<DATE()+30
UNION SELECT [Type], [Date]
FROM [Medical Record]
Where [Date]<DATE()+30
UNION SELECT[Type], [Date]
FROM [Violations Record]
Where [Date]<DATE()+30;
BUT, how do I get 2 columns from another table (Name and Plant) that are related by the primary key?