I used (make query table tool), then published the result but I found massage say “layer data source is not supported”
as the attached screenshot
Any help regard this?
I am not completely sure if the Query Table is a supported Data Source.
Unsupported data sources Suggested alternatives
Convert the data to feature classes in a geodatabase.
Import CAD content into a geodatabase feature class.
Generate features for each Excel spreadsheet and load the resulting feature classes into a geodatabase feature class.
ArcIMS feature service
Load the original data source into a geodatabase feature class.
In-memory feature class
Save in-memory data as a feature class in a geodatabase.
The layer that is created by the tool is temporary and will not persist after the session ends unless the document is saved.
So this "maybe" the issue.
I don't think non-persistent data sources, (like the output of the Make Query Table tool), are supported. You can try to create a view in the database/geodatabase that joins the tables so a data source is persisted there and see if you can publish.