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