Survivor table

[Marine]

I added in a column to my SURVIVOR table called NAME.

Now what im trying to figure out how to do is pull the data from the PROFILE table NAME column and have them correctly place beside the corrisponding unique_ID on the SURVIVOR tables NAME column.
How do I go about doing this? I need it to stay updated like if i open the table or refresh it. Kind of like the worldspace is always staying updated.

anyone know how to do this?

 

[TheLaughingMan]

Select distinct p.name, s.unique_id from profile p
inner join survivor s
on p.unique_id = s.unique_id;

There is a select statement to line them up.

 

[Marine]

Select distinct p.name, s.unique_id from profile p
inner join survivor s
on p.unique_id = s.unique_id;

There is a select statement to line them up.

Awesome so this pulls the right data I wanted, but basically I am trying to get the NAME column displaying in the SURVIVOR table the same way as it is in the PROFILE table. That way I can keep less tabs open and makes it easier to find players and their ID without jumping back and forth.

How do the names and IDs get posted to the PROFILE table automatically? Can I insert a code in somewhere in a sqf file that will make the NAME column post the same way in my SURVIVOR table?