In ArcGIS Pro 2.9, the arcpy.ListFields function returns an error message stating that the in_memory or table does not exist when viewing the output of the arcpy.management.MakeQueryTable function.

Workaround

In Step 4, add the entire path of the book_dissolve feature class and do not use the in_memory workspace location as shown below:

test_view = arcpy.management.MakeQueryTable('C:\\Users\\ANIKETD\\Downloads\\from_nevada_county\\for_esri_case.gdb\\book_dissolve', 'books')

arcpy.ListFields(test_view)

The result shows:

[<Field object at 0x2143b6b5a48[0x21400a02bb0]>, <Field object at 0x214009d7248[0x21400a028b0]>, <Field object at 0x214009d7548[0x21400a02970]>, <Field object at 0x214009d7e08[0x214009d89f0]>, <Field object at 0x214009d78c8[0x214009d83d0]>]

Steps to Reproduce