ambigous ::: Help

[igorek]

mysql> update tbl_content inner join tbl_menu inner join tbl_submenu using(col_pagenumber) set tbl_content.col_lang='ru', tbl_menu.col_lang='ua', tbl_submenu.col_lang='ua' where tbl_content.col_pagenumber = 10101;

1052 - Column 'col_pagenumber' in from clause is ambiguous

[igorek]

grrrr..... alll done i used a coma before my where statement and forgot to use USING() for the 3rd table...

basicly:

update t1
left join t2 using(id)
left join t3 using(id)
set
t1.name='value',
t3.name='value',
t2.name='value' >,<(i put a coma there by accident.) made me so mad because i had over 50 columns to update with dynamic values><<<<
WHERE id=1;