The context in which you want to do this is missing. This could be a calculation in a calculaiton field, a text field with an auto-enter calculation or a script step.
The calculation field version might be:
If ( IsEmpty ( AdditionalPhoto::Note ) ; Product::StyleName ; AdditionalPhoto::Note )
But note that you have fields from two table occurrences. THe above calculation will only work if there are valid relationships linking the two occurrences.