SQL statement (moving field contents)

[skittle]

Hi everybody,

I want to do following:

Take the information of movies field A and move it to the custom field B for every single movie I have in my database.

What I am thinking of is writing a short SQL like following:

UPDATE customfields_table C SET C.mycustomfield=(SELECT M.release FROM movies M);

The question is how to find out the right column and table names of the custom field (marked red)? Or is there an out-fo-the-box way to do what I am attempting to?

[rick.ca]

The question is how to find out the right column and table names of the custom field (marked red)?

Assuming you understand SQL and know how to use the SQL tool (on the Help menu when the program is started with the -debug switch), you could get those using an SQL query tool like FlySpeed SQL Query.

Or is there an out-fo-the-box way to do what I am attempting to?

Not exactly "out-of-the-box," but you could export [A] with [Title], [Year] and/or [ID] (to match records) and import the A data to [B].