I want to add two tables in geodatabase view (see attached). Those two table can not be related (attributes tables)
I am struggling with the SQL statement
You haven't provided any of the details that would permit us to help you. Among the things missing:
I always use SQL directly to construct views.
The RDBMS (including version)
Version of ArcGIS
Detailed descriptions of all columns in both tables
If the tables have geometry columns, the geometry storage type(s)
The column(s) the tables have in common
The indexes available on those columns
Retrieving data ...