scenario is: there is a flag field in my text table (news). Its type is the set collection, and the possible values are letters, such as "Agrappagh d". These letters correspond to a diyflag table with Chinese names corresponding to these letters. The two tables are as follows:
Article table news (where the flag field is the set collection type)
< table > < thead > < tr > < th > id < / th > < th > title < / th > < th > flag < / th > < / tr > < / thead > < tbody > < tr > < td > 1 < / td > < td > title 1 < / td > < td > a _ c < / td > < / tr > < tr > < td > 2 < / td > < td > title 2 < / td > < td > a td b < / td > < / tr > < tr > < td > 3 < / td > < td > title 3 < / td > < td > bline c < / td > < / tr > < / tbody > < / table >
property sheet diyflag
table is shown above, and what I want now is that the result of the query directly shows that the flag field is the corresponding Chinese name (such as headline, selected), rather than letters such as aforme b.
I would like to consult my brothers, thank you for your advice!