I don't see a 'highlighted' field.

First SELECT line defines field names and types. Not necessary to repeat alias names in subsequent SELECT but shouldn't hurt.
What data type is YourColumnName in each table?

SQL syntax looks fine.