MySQL UPDATE QUERY
hello I need help with an update query in MYSQL
I have 2 tables
c_item_property (TABLE NAME) c_document (TABLE Name
c_id int 1 to 1 c_id int
ref int 1 to 1 id int
visibility tinyint(4) path varchar
ok... so between the 2 tables I need to update the c_item_property table
with the 1 to 1 relationship (i think it might be a join.. not sure) between c_id .....and the ref to id 1 to 1 relationship.
I need to update visibility to 1 when path = '/week_03'
thanks for your help