I have gone through the process and have validated my SQL for my query layer. However it produces a standalone table. This does not work for me as i need a layer. It is my understanding that it produces a table when geometry and geography fields are missing from a table. The table in which im querying from resides on sde and is able to be drawn in arcmap. It has an ObjectID and a Shape(geometry) field. Do I need to configure anything else in order to get it to produce a a query layer and not a table?
when I look at advanced options, everything is grayed out, I suppose this means it cannot find the spatial properties such as shape type, Spatial Reference, Geometry SRID, etc... This puzzles me as i would have assumed that since it is an sde feature class it would have those parameters included.
We're probably going to need more information to help you:
What version of ArcGIS are you using? What service pack?
What database are you using (complete version).
What does 'sdetable -o describe' (and/or a native SQL 'describe') report
on the table(s) involved?
What does 'sdelayer -o describe_long' report on the geometry table(s)
A "query layer" isn't a table, it's a query against a table. In order to be seen as having a geometry column, the query must include a native or ST_GEOMETRY column and a rowid (objectid). It is not possible to create query layers against SDEBINARY or SDELOB storage layers.