var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update query
I have a table with the column dateapproved and in another table another column yearofapproval
i would want to extract the 'YYYY' from the dateapproved from table A and update it onto table B's column yearofapproval.
how to write a query for this? kindly advise.. thanks.
what you asked is what you get --
SET yearofapproval = ( SELECT MAX(YEAR(dateapproved)) FROM tableA )