I have two tables, XMemberT and VMemberT and I want add certain details into an extra column for VMemberT. (If ID matches, add name and age)

I need the end results where the added columns appear on the left side of VMemberT

I've been stuck trying to figure a way to get the desired results out. May I ask for some help, please?

CodePudding user response：

Use Join for Refrence purpose use this link https://www.w3schools.com/sql/sql_join.asp