How do I insert a Select Max from another table [duplicate]

Question

This is the code I have and I am not sure why it doesnt work

Insert INTO TEventGolfers (intGolferID, intEventID) Values((Select MAX(intGolferID) From TGolfers),4)

I want to insert 4 as the EventID and the max golfer id from the table TGolfers as the foreign key golfer id in the EventGolfers Table

What's expected to happen if someone later today inserts into TGolfers an even higher intGolferID value? (Your data in TEventGolfers will be out of date.) — jarlh
– jarlh, Commented Nov 21, 2019 at 8:27

Fahmi · Accepted Answer · 2019-11-21 08:03:50Z

3

You can try this-

Insert INTO TEventGolfers (intGolferID, intEventID) Select MAX(intGolferID),4 From TGolfers

answered Nov 21, 2019 at 8:03

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

The syntax used in OP should work as-is.

@SalmanA, yup, I know but this answer seems neater to me that OP's:)