The problem is that you need to list the fields you want in both tables, not just the point FC.
This is for all fields in both PointLayer and table:
SELECT PointLayer.*, Table.*
FROM PointLayer
JOIN Table
ON PointLayer.Assess = Table.Field2A
This is for only certain fields:
SELECT PointLayer.Field1A,
PointLayer.Shape,
PointLayer.OBJECTID,
Table.Field2B,
Table.Field2C,
Table.Field2D
FROM PointLayer
JOIN Table
ON PointLayer.Assess = Table.Field2A