In this question, In one workspace, There are many assets and other workspaces use them. but it is weak reference.
and now ,I hava asset value, I want to search all node using asset value without property name
If you want to search all the nodes which are referencing another node via a reference property, you can use the REFERENCE() operand: JCR-SQL2 - ModeShape 4 - Project Documentation Editor