Inner Join and Select Into from a Multiple Table

MakeTable_Query_2.htm

step 1

step 2

step:3

step 4

Step 5

step : 6

step 7

Step : 8 run and compile

Step : 9 alert message, confirms that everything going OK.

Step : 10 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 : 11 Table is created