# Display two different select statements in the data grid **URL:** \ **Category:** Idea Pond\ **Created:** [June 27, 2018, 10:13am UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293 "2018-06-27T10:13:00Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![cenkakbulut](https://avatars.discourse-cdn.com/v4/letter/c/71c47a/32.png) [@cenkakbulut](https://forums.toadworld.com/u/cenkakbulut)\ **Post date:** [June 27, 2018, 10:13am UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/1 "2018-06-27T10:13:00Z")
Hello I've just started using TOAD and I really admire lots of its features but there's something bothers me: I cannot see two different select statement's result in two tabs like SQL Developer or SQL Management Studio. Maybe you might think that is a good idea and put this feature in one of next versions of TOAD? Thank you! ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [July 2, 2018, 5:52pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/2 "2018-07-02T17:52:40Z")
Here's one way to do it.  If you have the latest version 13.x of Toad/Oracle, then select View-\>Options and highlight the "General" page.  You'll see the "Application Style" options... by default, Toad has always used MDI (Multiple Document Interface.)  Select SDI instead, and restart Toad. The SDI setting will allow most panels/windows in Toad to "float".  You'll be able to drag them anywhere, including from monitor to monitor.  Then, it's easy to bring up two separate instances of the Editor, execute your two different queries, and then position the two Data Grids side by side for easy viewing. ---
**Author:** ![jslindo](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jslindo](https://forums.toadworld.com/u/jslindo)\ **Post date:** [October 25, 2018, 7:03pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/3 "2018-10-25T19:03:37Z")
The idea is not with SDI. The idea is have two select, and execute the two select one time. The grid of output is split in two grid with date of one select and data of other select, The microsft sql manager have this option. ---
**Author:** ![jslindo](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jslindo](https://forums.toadworld.com/u/jslindo)\ **Post date:** [October 25, 2018, 7:08pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/4 "2018-10-25T19:08:31Z")
![imagem](https://global.discourse-cdn.com/quest/original/2X/c/cf33d4bb246cf587b7869ace35e8064372fcec26.png) See the image. The idea is like the image ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [October 26, 2018, 4:41pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/5 "2018-10-26T16:41:24Z")
Ah, you mean, like this? When you execute the contents of the Toad Editor as a script, the Script Output tab should show the individual data grids. Hope this gets you closer! ![image](https://global.discourse-cdn.com/quest/original/2X/c/ce7f3552d4db3d738f17105ad411338b84608553.png) ---
**Author:** ![jslindo](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jslindo](https://forums.toadworld.com/u/jslindo)\ **Post date:** [October 26, 2018, 5:17pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/6 "2018-10-26T17:17:23Z")
Is not the same. To compare the select i need change tab focus. When i see data in grid1 i not see data in grid2. Other solution is two editor, and rezise the windows of editor to view the data of grid1 and grid2. But this solution reduce the size of data grid in ecran ---
**Author:** ![jslindo](https://avatars.discourse-cdn.com/v4/letter/j/b5ac83/32.png) [@jslindo](https://forums.toadworld.com/u/jslindo)\ **Post date:** [October 26, 2018, 5:20pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/7 "2018-10-26T17:20:29Z")
how can obten the two grid. when i execute two select only have the grid of last select, and in script output don't have the grids ![imagem](https://global.discourse-cdn.com/quest/original/2X/1/146c7cb42e4e3726e44db632b197a114acb91f4a.png) ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [November 29, 2018, 7:27pm UTC](https://forums.toadworld.com/t/display-two-different-select-statements-in-the-data-grid/42293/8 "2018-11-29T19:27:07Z")
Another option is to use the Single Doc Interface (choose SDI in Toad options for Toad version 13.0 and above), run each query in a separate editor, then drag one of the editor and its data grid underneath the other grid, or even drag one of the editor/grids to a separate monitor to maximize your screen viewing real estate.