Cross Connection Queries

Toad Data Point
1

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

2

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