first of all, you cannot do a SELECT and an UPDATE in the same statement
they are intrinsically different, and they must be separate statements
if you want to do them "together" then perhaps you might want to create a transaction, but this is likely only in situations where the update needs to happen only on the rows which you selected, and before any other rows are inserted or updated...
... which seems quite unreasonable, given the example you've posted
secondly, your LEFT OUTER JOIN will actually behave as an inner join, based on the existence of the WHERE clause...
... and the WHERE clause is redundant with your ON clause
what's actually going on here?
why do you need to select first? why not just go ahead and update the men's fabric to say 'both' when the titles are equal?
and why do you have separate tables for men's and women's fabric? couldn't there just be one table with a designator for men's or women's or both?