I am truly frustrated with what should be a simple update. Any help to enlighten this newbie is appreciated.
[TABLE A] tdmr_dmr ================ dmr_customer_code dmr_job_number_code [TABLE B] tjl_job_list ================ jl_customer_code jl_jobnumber In Table A, the dmr_customer_code field is empty. So I need to populate with jl_customer_code data from Table B.....into dmr_customer_code in Table A........for matching job numbers. I thought the command would simply be as follows: UPDATE tdmr_dmr, tjl_job_list SET tdmr_dmr.dmr_customer_code = tjl_job_list.jl_customer_code WHERE tdmr_dmr.dmr_job_number_code = tjl_job_list.jl_jobnumber But I keep getting this error from my admin tool, although I can't figure out what is wrong. You have an error in your SQL syntax near ' tjl_job_list SET tdmr_dmr.dmr_customer_code = tjl_job_list.jl_customer_cod' at line 1 Any help is deeply appreciated. Thanks!!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]