I have a fetch xml created
<fetch version="1.0" mapping="logical" output-format="xml-platform">
<entity name="asrt_ecsdocumentmetadata">
<attribute name="asrt_ecsdocumentmetadataid" />
<attribute name="asrt_enteredreferencenumber" />
<attribute name="asrt_entereddatetaken" />
<attribute name="asrt_enteredcreditsearned" />
<attribute name="asrt_ecsqueuestatustype" />
<order attribute="createdon" descending="true" />
<filter type="and">
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="asrt_contactid" operator="eq" value="@ct@" />
</filter>
<link-entity name="asrt_document" alias="asrt_ecsdocumentmetadata56e" to="asrt_documentid" from="asrt_documentid" link-type="inner">
<attribute name="asrt_httpurl" />
</link-entity>
</entity>
</fetch>
only shows one value for <attribute name="asrt_httpurl" /> there are mutiple rows an in DB inner join shows all rows with asrt_httpurl value. whats wrong with the fetch xml?