# \#openquery

**URL:** https://community.cdata.com/tag/openquery/590.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [SOQL passed via DBAmp to Salesforce using openquery does not return all rows.](https://community.cdata.com/t/soql-passed-via-dbamp-to-salesforce-using-openquery-does-not-return-all-rows/981)

<div class="topic-metadata">

**Author:** [@HRMiller](https://community.cdata.com/u/HRMiller)\
**Replies:** 0\
**Last updated:** [December 28, 2024, 12:25am UTC](https://community.cdata.com/t/soql-passed-via-dbamp-to-salesforce-using-openquery-does-not-return-all-rows/981 "2024-12-28T00:25:27Z")

</div>

soql passed through dbamp to salesforce using openquery syntax selects from Contact and includes select from child table. See query below. For the ID specified in the query there are 13 records in the child table whi…