# Pick list gives me columns from wrong table **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [June 22, 2015, 4:51am UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552 "2015-06-22T04:51:57Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Carl\_L](https://avatars.discourse-cdn.com/v4/letter/c/898d66/32.png) [@Carl\_L](https://forums.toadworld.com/u/Carl_L)\ **Post date:** [June 22, 2015, 4:51am UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552/1 "2015-06-22T04:51:57Z")
Hi, I have just updated to Toad for Oracle 12.6.0.53 and have discovered a new "feature" when multiple tables in the same editor (in different statements) are given the same alias.... Previously, the pick list returned the columns from the table within the relevant statement. Now it returns the columns from the top table with the specific alias even if the cursor is in a completely different statement. I have included a screen print below. As can be seen does the pick list show the columns from "all\_tables" and not "all\_tab\_columns" as I would like it to. Can this be changed anywhere. It is really annoying as I have always used a,b,c,d,... as alias. In advance, thanks Carl ![8712.Toad.png](https://global.discourse-cdn.com/quest/original/2X/6/65137115ad02b9f14dd2a73bc1e8ba040c14a62b.png) ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [June 22, 2015, 4:57am UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552/2 "2015-06-22T04:57:10Z")
Terminate your first statement with a semicolon and it will show correctly. On Jun 22, 2015, at 7:52 AM, Carl\_L [bounce-Carl\_L@toadworld.com](mailto:bounce-Carl_L@toadworld.com) wrote: > **[Pick list gives me columns from wrong table](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24796.aspx)** > Thread created by Carl\_L > Hi, > I have just updated to Toad for Oracle 12.6.0.53 and have discovered a new "feature" when multiple tables in the same editor (in different statements) are given the same alias.... > Previously, the pick list returned the columns from the table within the relevant statement. Now it returns the columns from the top table with the specific alias even if the cursor is in a completely different statement. > I have included a screen print below. As can be seen does the pick list show the columns from "all\_tables" and not "all\_tab\_columns" as I would like it to. > Can this be changed anywhere. It is really annoying as I have always used a,b,c,d,... as alias. > In advance, thanks > Carl > > To reply, please reply-all to this email. > > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24796.aspx?subscribe=false) on this subject. > > Or [ > Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. > > Toad for Oracle - Discussion Forum > [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24796.aspx?AbuseContentId=7bb86e3e-03dc-4ad1-9a28-8b72055b7a58&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) > this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) ---
**Author:** ![Carl\_L](https://avatars.discourse-cdn.com/v4/letter/c/898d66/32.png) [@Carl\_L](https://forums.toadworld.com/u/Carl_L)\ **Post date:** [June 23, 2015, 1:55am UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552/3 "2015-06-23T01:55:42Z")
Hi, Thanks for the answer. Is there a way to chage this so that it works like in previous versions (that is, whithout having to use the semicolon)? A small thing of course, but it would be very nice since I am very used to this after 8 years of Toad usage… Br, Carl ---
**Author:** ![RoDJeR](https://avatars.discourse-cdn.com/v4/letter/r/ecc23a/32.png) [@RoDJeR](https://forums.toadworld.com/u/RoDJeR)\ **Post date:** [February 8, 2022, 1:21pm UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552/4 "2022-02-08T13:21:35Z")
This problem with the semicolon is still relevant, will it be fixed in new versions of Toad? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [February 10, 2022, 1:35pm UTC](https://forums.toadworld.com/t/pick-list-gives-me-columns-from-wrong-table/33552/5 "2022-02-10T13:35:03Z")
I'm not saying it will never be fixed, but it is low priority. The editor can do a better job of parsing your sql if you tell it where your statements end. Blank lines in SQL are acceptable. But if you have no semicolons, we have to start guessing where your sql begins and ends. It's really best if you have semicolons.