Inner Join and Select Into from a Multiple Table

MakeTable_Query_2

Objectives:

Querying Access DB, using graphical tools.
INNER_Joins

step

step:

step

Step

step :

step

Step run and compile

Step alert message, confirms that everything going OK.

Step : Query details

SELECT WineProposal.Producer, DB.Varietal, cWineProposal.Supplier, cWineProposal.Type INTO testwine_1
FROM (WineProposal INNER JOIN DB ON WineProposal.ID = DB.ID) INNER JOIN cWineProposal ON WineProposal.ID = cWineProposal.ID;

step Table is created