Insert query into table FROM two table sources

[svcghost]

Hey guys.

I'm trying to insert data FROM two tables into single records of a different table.

So there are three tables: 1 destination, 2 sources

I'm using the docmd.runsql vba function.. here's what I have:

DoCmd.RunSQL ("INSERT INTO SuiteEvents(Account, Section, Row, Seats, 
NumSeats1, TypeSeat, Name, EventCode, EventDate, MaxSeats, MaxParking, Parking, Price) 
SELECT AccountNumber, Section, Row, Seats, NumSeats1, TypeSeat FROM SuiteAccounts, 
SELECT EventName, EventID, EventDate, SuiteMaxSeatCount, SuiteMaxParkingPass, 
SuiteParkingPass, L_Price FROM EventPrep;")

I know this code is wrong, but how can I use two SELECT statements as sources from different tables, to insert into a new destination table?

Thanks guys!

[TheShabz]

you would use this format...

INSERT INTO tablename (field1, field2, field3)
SELECT table1.field1, table1.field2 table2.field3
FROM table1, table2
WHERE (something connecting the two tables)

[svcghost]

Thanks. I just used a left join instead of joining with the WHERE clause. Thanks man.

Would give you REP but I gotta share the wealth first it appears.. hah