SQL query in the data link connection

Greetings,

 

I have this query set up in my data link section to return Zoning types when it intersects a parcel layer:

 

SELECT a.LABEL as "Zoning Label", 'Zoning: ' as zoning 

 

FROM SCD_GIS_PUBLISH.SCD_GDBA.ZONING__CURRENT__zoningdissolve_poly a,

 

SCD_GDBA.GIS_FEATURES_DBA_CADASTRAL_PARCELS_ASSESSOR b

 

WHERE b.PARCEL_ID = @ParcelID

 

and b.shape.STBuffer(-10).STIntersects (a.shape) = 1

 

ORDER BY a.LABEL ASC

 

This data link is then put into a map tip window with the intent of trying ot list any and all zoning types that intersect that parcel. For the most part, it is just one type zoning for every parcel but throughout our area, we have roughly 4500 parcels that have multiple types of zoning and we wish to convey that information via listing them in the map tip, like so:

 

 

Given the query above and the html code present in the map tip, can we actually get a return of all values to show up in the map tip?

 

Currently, they will only show the 1 result but in the view additional details tab, under that results section, we will actually find a list of all the zoning types returned from that intersteciton with the underlying parcels layer.

 

Any insight is greatly appreciated.

 

Raoul