ArcGIS Pro 3.1.1; file geodatabase
I have a FGDB table called TEST_TABLE.
I've created a database view on the table called TEST_TABLE_NT_FLAG_VW:
select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table
I've opened the table in the map and created a join via the OBJECTID.

Result:
The join didn't work. The join fields are null in the attribute table:

Video:
Question:
Why are the join fields blank in the FGDB join?
I don't have that problem in mobile or enterprise geodatabases.