# Cross Connection Queries

**URL:** <https://forums.toadworld.com/t/cross-connection-queries/39453>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [May 11, 2017, 9:09am UTC](https://forums.toadworld.com/t/cross-connection-queries/39453 "2017-05-11T09:09:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zentel1](https://avatars.discourse-cdn.com/v4/letter/z/ed8c4c/32.png) [@Zentel1](https://forums.toadworld.com/u/Zentel1)\
**Post date:** [May 11, 2017, 9:09am UTC](https://forums.toadworld.com/t/cross-connection-queries/39453/1 "2017-05-11T09:09:39Z")

</div>

Hello All,

I am new to TDP and i was wondering if i can get help in creating WITH statements in cross connection queries. I am querying data from different database platforms like MSSQL and Oracle.

Please any assistance is greatly appreciated. Thank you

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [May 11, 2017, 10:29am UTC](https://forums.toadworld.com/t/cross-connection-queries/39453/2 "2017-05-11T10:29:23Z")

</div>

The with statement is not support in Cross-Connection queries. I would use the Cross-Connection Query Builder from main menu to build queries. it knows the correct syntax to use. Then if you need to retain the result set I would save to Local Storage