Linking content types
A better way to do it is replacing the asset ID field with an entity reference field which refers to the other content type (Asset) and use view relations to get the relation. In short, create a relation between the content types, and you will be able to use view relations. 

For advanced uses, you can take a look to the Relation module, which I don't recommend, in your case.