# TDP 3.6 cross join SQL / Excel **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [August 13, 2015, 11:42am UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921 "2015-08-13T11:42:08Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Blister](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Blister](https://forums.toadworld.com/u/Blister)\ **Post date:** [August 13, 2015, 11:42am UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921/1 "2015-08-13T11:42:08Z")
Hi, I need to join an Excel file to my Oracle SQL and use it as a look up - linking it on a key field. I read a few articles that indicated this can be done… How? I have my Excel Linked and can run a simple select query against it that returns data. I’d like to do a JOIN in my Oracle SQL to it and have the results (dataset) have additional columns from the excel WHERE the kkey fields match… …any info would be greatly appreciated… Thanks, from sunny southern california… ---
**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:** [August 13, 2015, 5:55pm UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921/2 "2015-08-13T17:55:43Z")
First make sure you are connected to Excel just like any other connection. After you connect to oracle open up the Cross-Connection Query Builder from the menu. ![xquery4.png](https://global.discourse-cdn.com/quest/original/2X/f/f751e3a0c5116e23ab1045c7f63ee34771d71cef.png) Then drag in a table from each connection. The Object explorer will list all objects from both connections. Create the join by dragging one column over to the other. Select your columns and add where condition and execute. ![xquery3.png](https://global.discourse-cdn.com/quest/original/2X/0/0e386eb08b495ca758a03eff6739d0825ba85c21.png) ---
**Author:** ![Blister](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@Blister](https://forums.toadworld.com/u/Blister)\ **Post date:** [August 14, 2015, 9:52am UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921/3 "2015-08-14T09:52:22Z")
Thanks - this is exactly what I was looking for… --------\*\* Donald Piazza\*\* Lead Business Consultant, Administrative Programs Medicaid & Charitable Health Coverage **Kaiser Permanente** HPPSA - Membership Administration & Benefits Administration 3840 Murphy Canyon Road San Diego, CA 92123 (858) 614-3086 (office) 8-279-3086 (tie-line) (858) 264-7344 (mobile phone) * * * **kp.org/thrive** **NOTICE TO RECIPIENT:** If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank you. From: “Debbie Peabody” [bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com) To: [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com) Date: 08/13/2015 05:57 PM Subject: RE: [Toad Data Point - Discussion Forum] TDP 3.6 cross join SQL / Excel * * * [**RE: TDP 3.6 cross join SQL / Excel**](http://www.toadworld.com/products/toad-data-point/f/36/p/25237/55599#55599) Reply by Debbie Peabody First make sure you are connected to Excel just like any other connection. After you connect to oracle open up the Cross-Connection Query Builder from the menu. Then drag in a table from each connection. The Object explorer will list all objects from both connections. Create the join by dragging one column over to the other. Select your columns and add where condition and execute. To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/25237?subscribe=false) on this subject. Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36?subscribe=false) notifications altogether. Toad Data Point - Discussion Forum [Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/25237/55599?AbuseContentId=bdd3c266-cacc-412a-896e-804d40a28373&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ---
**Author:** ![liya.guo](https://avatars.discourse-cdn.com/v4/letter/l/e99b99/32.png) [@liya.guo](https://forums.toadworld.com/u/liya.guo)\ **Post date:** [February 25, 2016, 9:39am UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921/4 "2016-02-25T09:39:13Z")
I am using TDP 3.7 Base version, but can’t find the menu for Cross-Connection Query Builder. I have ODBC connection to Oracle db and Excel Connection to a file. Is the Cross-Connection query supported in 3.7 base? or am I missing something? Thanks, ---
**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\ **Post date:** [February 25, 2016, 5:07pm UTC](https://forums.toadworld.com/t/tdp-3-6-cross-join-sql-excel/33921/5 "2016-02-25T17:07:05Z")
Liya, Cross-Connection Query is only available in Pro edition. Please consider update your TDP to pro. Thanks!