Values of a column in X1 in table X to be equaled to the value of Column Y1 in table Y

I need to know the expression to use to make duplicate of column value

where the Values of a column in X1 in table X to be equaled to the value of Column Y1 in table Y

Where the data entry shall be in table Y, column Y1