(SOLVED)Help generating SQL table with data from different tables

[TC_]

I'm ultimately needing to generate a table such as this:

CREATE TABLE Resources_Types_And_Improvements(ResourceType, ResourceClassType, ImprovementType);

It's no problem to generate these types:

CREATE TABLE Resources_And_Class(ResourceType, ResourceClassType);
INSERT INTO Resources_And_Class(ResourceType, ResourceClassType)
SELECT ResourceType,
ResourceClassType
FROM Resources;


CREATE TABLE Resources_And_Improvement(ResourceType, ImprovementType);
INSERT INTO Resources_And_Improvement(ResourceType, ImprovementType)
SELECT ResourceType,
ImprovementType
FROM Improvement_ValidResources;

But I don't know how to combine the two, as the data I need comes from different tables. Could someone point me in the right direction? I assume the way to do it is as follows, but I'm not sure how to pull the ImprovementType in my UPDATE statement:

CREATE TABLE Resources_Types_And_Improvements(ResourceType, ResourceClassType, ImprovementType);

INSERT INTO Resources_Types_And_Improvements(ResourceType, ResourceClassType)
SELECT ResourceType,
ResourceClassType
FROM Resources;

UPDATE Resources_Types_And_Improvements
SET ImprovementType ???

Thank you in advance!

 

[TC_]

I did some more research, and am now trying this:

INSERT INTO Resources_Class_Improvement(ResourceType, ResourceClassType, ImprovementType)
SELECT ResourceType, ResourceClassType FROM Resources
LEFT JOIN Improvement_ValidResources ON Resources.ResourceType = Improvement_ValidResources.ResourceType;

But, to no avail.

 

[TC_]

Got it working, as follows:

CREATE TABLE Resources_Improvement_Full AS
SELECT * FROM Resources
LEFT JOIN Improvement_ValidResources ON Improvement_ValidResources.ResourceType = Resources.ResourceType;

CREATE TABLE Resources_Improvement_Trimmed AS
SELECT ResourceType, ImprovementType, ResourceClassType FROM Resources_Improvement_Full;